5種資料庫的ConnectionString

1. MS Access 2003 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myfile.mdb;User Id=admin;Password=; 2. MS Access 2007 Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\ myfile.accdb;Persist Security Info=False; 3. SQL Server 2005或者SQL Server: Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; 如果是Trusted Connection那麼可以是: Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; 其中, Data Source是SQL Server機器的IP Address或在網路中的名字. Initial Catalog是那台機器中的某個Database, 然後需要有正確的用戶名密碼. 4. Oracle Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; 如果是Trusted Connection那麼可以是: Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes; 5. MySQL Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;