Creating new database 'Views' in Server Explorer

Seven

Hi,

When I right-click the View Node of a database connection (in server
explorer), I only get the 2 choices: "Refresh" and "Properties".

Therefore I was wondering how can I set up Visual Studio to allow me to add
and setup new "Views" in a database? I don't know if it is something I need
to do to the database, visual studio, IIS or if its a security setting that
is extant on my PC.

I get the same problem with the "Stored Procedures" node aswell

Thanks in advance for your help

Jon

Oct 29 '06 #1

Mark Fitzpatrick

Which database type are you connecting to and what version (ie: Sql Server
2000). You may want to play around with a different connection type just in
case you chose a connection type that limits what can be done with the
database.

--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Seven" <Se***@discussions.microsoft.comwrote in message
news:12**********************************@microsof t.com...

Hi,

When I right-click the View Node of a database connection (in server
explorer), I only get the 2 choices: "Refresh" and "Properties".

Therefore I was wondering how can I set up Visual Studio to allow me to
add
and setup new "Views" in a database? I don't know if it is something I
need
to do to the database, visual studio, IIS or if its a security setting
that
is extant on my PC.

I get the same problem with the "Stored Procedures" node aswell

Thanks in advance for your help

Jon

Oct 29 '06 #2

Seven

I get the same problem for both an SQL Server 2000 and for an Access 2003
database.

What do you mean by "connection type"? are you referring to the Provider?

If it helps, for SQL I am using the "Microsoft OLE DB Provider for SQL
Server" and for access I am using the "Microsoft Jet 4.0 OLE DB Provider"

Thanks

"Mark Fitzpatrick" wrote:

Which database type are you connecting to and what version (ie: Sql Server
2000). You may want to play around with a different connection type just in
case you chose a connection type that limits what can be done with the
database.

--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Seven" <Se***@discussions.microsoft.comwrote in message
news:12**********************************@microsof t.com...

Hi,

When I right-click the View Node of a database connection (in server
explorer), I only get the 2 choices: "Refresh" and "Properties".

Therefore I was wondering how can I set up Visual Studio to allow me to
add
and setup new "Views" in a database? I don't know if it is something I
need
to do to the database, visual studio, IIS or if its a security setting
that
is extant on my PC.

I get the same problem with the "Stored Procedures" node aswell

Thanks in advance for your help

Jon

Oct 29 '06 #3