各种数据库连接字符串

数据库连接字符串大全 http://www.connectionstrings.com

SqlServer

"Data Source=localHost;Initial Catalog=Agile;User Id=sa;Password=****;"

Oracle  

"Data Source=127.0.0.1/Agile;User Id=orcl;Password=****;"

Mysql  

"Server=127.0.0.1;Port=1234;Database=Agile;Uid=root;Pwd=****;"

DB2

"Server=127.0.0.1:1234;Database=Agile;UID=DBADM;PWD=****;"

PostgreSql  

"Server=127.0.0.1;Port=5432;Database=Agile;User Id=postgres;Password=****;"

Sqlite  

"Data Source=|DataDirectory|DataBase.db;Version=3;"

Access  

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DataBase.mdb;User Id=;Password=;"

 

转载于:https://www.cnblogs.com/MuNet/archive/2012/08/10/5757775.html