Connecting from Visual Studio 2010 to SQL Server Management Studio
-
I have created tables in SQL Server Management Studio which I want to use in a program I have in VS 2010. When you check the properties of the tables in Management Studio there doesn't appear to be an actual path that you can use as a connection string. Can anybody help me with this? Thanks Darrall
-
I have created tables in SQL Server Management Studio which I want to use in a program I have in VS 2010. When you check the properties of the tables in Management Studio there doesn't appear to be an actual path that you can use as a connection string. Can anybody help me with this? Thanks Darrall
http://www.connectionstrings.com/[^] You already have SSMS open and connected to a database and you can't figure out a connection string to use? :rolleyes:
I know the language. I've read a book. - _Madmatt
-
http://www.connectionstrings.com/[^] You already have SSMS open and connected to a database and you can't figure out a connection string to use? :rolleyes:
I know the language. I've read a book. - _Madmatt
-
A fair enough observation except that it doesn't want the path to the database itself...it wants the path to the file that I created within the database and that path I can't find.
Darrall wrote:
the path to the file that I created within the database
I have no idea what you're talking about
I know the language. I've read a book. - _Madmatt
-
A fair enough observation except that it doesn't want the path to the database itself...it wants the path to the file that I created within the database and that path I can't find.
I find that hard to believe. Are you sure it's not Access?
-
A fair enough observation except that it doesn't want the path to the database itself...it wants the path to the file that I created within the database and that path I can't find.
For an SQL Server connection string, you specify the database name, not the path to the database file. The sole exception to that would be if you were using SQL Server Express.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
For an SQL Server connection string, you specify the database name, not the path to the database file. The sole exception to that would be if you were using SQL Server Express.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...