数据库连接字符串(MySQL,Oracle,SQL Server2000/2005/2008,SQLite,Access)

1.MySQL Connector/.NET
连接类型：NET Framework类库
命名空间：MySql.Data.MySqlClient.MySqlConnection

1)标准连接字符串：Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
2)指定TCP端口：Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
2)多台服务器：Server=serverAddress1, serverAddress2, serverAddress3;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

2.Oracle Data Provider for .NET / ODP.NET
连接类型：NET Framework类库
命名空间：Oracle.DataAccess.Client.OracleConnection

1)使用TNS：Data Source=TORCL;User Id=myUsername;Password=myPassword;
TNS：数据连接字符串，代表一个数据库连接的串。这个串可以在oracle安装根目录\ora92\network\admin\tnsnames.sql里面找到：
orac   =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = cyl)(PORT = 1521))
       )
       (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = D7i)
       )
   )
上面的 "orac",就是需要的TNS,可以自己复制重写一个TNS,把HOST指向数据库服务器IP，SERVICE_NAME =数据库sid
2)使用集成的安全性：Data Source=TORCL;Integrated Security=SSPI;

3.SQL Server2000/SQL Server2005/SQL Server2008
连接类型：NET Framework类库
命名空间：System.Data.SqlClient.SqlConnection

1)标准安全性：Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
2)Trusted Connection：Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
3)

4.SQLite/.NET
连接类型：NET Framework类库
命名空间： System.Data.SQLite.SQLiteConnection

1)基础连接：Data Source=c:\mydb.db;Version=3
2)连接内存中的数据库：Data Source=:memory:;Version=3;New=True;
3)使用UTF16：Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;
4)设置密码：Data Source=c:\mydb.db;Version=3;Password=mypassword;
5)连接池：Data Source=c:\mydb.db;Version=3;Pooling=false;Max Pool Size=100;

5.Access/Microsoft Jet OLE DB4.0
连接类型：OLE DB Provider

1)标准安全性：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydatabase.mdb;User Id=admin;password=;
2)设置数据库密码：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;
3)工作组(系统数据库)：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;

参照网址：http://connectionstrings.com/