Friday, April 4, 2008

Connection Strings

SQL Connection String
Data Source=ServerName;Initial Catalog=DatabaseName;Persist Security Info=True;User ID=username;Password=password;

OLEDB Connection String
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=username;Password=password;


Oracle Connection String
Provider=msdaora;Data Source=MyOracleDataBase;User Id=myUsername;Password=myPassword;

No comments: