Thursday, October 16, 2008

List of Connection strings for different Databases from .Net

Ms-Access :

Provider=Microsoft.Jet.OLEDB.4.0DataSource=C:\mydatabase.mdb;UserId=admin;Password=;


Sql server :
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

My Sql :
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

Oracle :
Provider=msdaora;DataSource=MyOracleDB;UserId=myUsername;Password=myPassword;

For More Connection Strings Click Here

No comments: