Wednesday, November 5, 2008

Connetion strings in ASP.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;

No comments: