By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

Creating new database 'Views' in Server Explorer

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.