DotNet連接數據庫的方法
The SQL Server .Net Data Provider
連接SQL Server數據庫
"data source=服務器名;initial catalog=數據庫名;user id=sa;passWord=;"
The OLE DB .Net Data Provider
連接SQL Server數據庫
"Provider=SQLOLEDB;Persist Security Info=False;Data Source=服務器名;Initial Catalog=數據庫名;User ID=sa;PassWord=;"
連接Oracle數據庫
"Provider=MSDAORA;Data Source=服務器名;User ID=用戶ID;PassWord=密碼;"
連接Access數據庫
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*.mdb"
Oracle客戶端連接Oracle
連接Oracle 7
"Provider=MSDAORA.1;User ID=;Data Source=;PassWord="
連接Oracle 8
"Provider=OraOLEDB.Oracle.1;User ID=;Data Source=;PassWord="
DotNET Managed Provider for Oracle
連接Oracle 8
"Data Source=; User ID=; PassWord="
命名空間是System.Data.OracleClIEnt