ADO中数据库连接字符串的几种写法

转自http://blog.csdn.net/niuzai520/article/details/6778645

MsSql连接：

string  value= "Data Source=LocalHost;Initial Catalog=DbName;Integrated Security=SSPI";

string  value= "Data Source=TC019053;Initial Catalog=DbName;User ID=sa;Password=****";

string  value= "server=localhost;database=DbName;User ID=sa;Password=****";

string  value= "server=localhost;database=DbName;Integrated Security=SSPI";

MySql连接：

string value="server=localhost;database=DbName;user id=root;password='';pooling=false";

SQLite连接：

string value="Data Source=|DataDirectory|/DbName.s3db";

Access连接：

[2003] string value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/MyDb.mdb;"

[2007]  string value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/MyDb.accdb;"

 

oracle连接:

string value="Data Source=ProjectOracle;password=****;user ID=system";