Wednesday, March 21, 2012

Is the connection string for SQL Server and MSDE the same?

The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVER\VSDOTNET;Database= CCDDbase;Integrated Security=SSPI

would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...You'll obviously have to change the variable parts of your connection string like the server and database names, but other than that you are "good to go" using the same connection string.

-PatP|||Here's a nice little URL for your favorites:

http://www.connectionstrings.com/

No comments:

Post a Comment