SQL Server OLEDB DSNLess connection string sample

SQL Server OLEDB DSNLess connection string sample

Here are two examples of SQL Server 2000 connection strings:

"Provider=SQLOLEDB;Data Source=myserver;User ID=myuser;Password=mypwd;Initial Catalog=mydb"

or if db is on the same server...

"Provider=SQLOLEDB;Data Source=(local);User ID=myuser;Password=mypwd;Initial Catalog=mydb"


Submission Date:  8/9/2001 2:03:00 PM
Submitted By:  Robbe Morris
My Home Page:  http://www.robbemorris.com

By Robbe Morris   Popularity  (598 Views)
Picture
Biography - Robbe Morris
Robbe has been a Microsoft MVP in C# since 2004. He is also the co-founder of NullSkull.com which provides .NET articles, book reviews, software reviews, and software download and purchase advice.  Robbe also loves to scuba dive and go deep sea fishing in the Florida Keys or off the coast of Daytona Beach. Microsoft MVP