各种数据库连接字符串

SqlServer 

“Data Source=127.0.0.1; Initial Catalog=dbname;User Id=sa;Password=****;”

Oracle

"Data Source=127.0.0.1/dbname;port=1521;User Id =orcl; Password=***'*;"

DB2

"Server=127.0.0.1:50000;Database=dbname;UID=DBADM;PWD=****;"

MySql

"Server=127.0.0.1;Port=3306;Database=dbname;Uid=root;Pwd=****;"

PostgreSql

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

Sqlite

"Data Source=| DataDirectory|dbname.db;Version=3;Password=****"

Access

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

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

posted @ 2023-06-07 16:33  KevinSteven  阅读(23)  评论(0编辑  收藏  举报