ADO.net中數據庫連接方式
2024-07-21 02:07:22
供稿：網友
在msdn中，.net的數據庫連接字符串都有詳細的說明，我這里以代碼范例的方式羅列一些，具體的每一項代表的意義可以參看msdn.
ado.net 中數據庫連接方式(微軟提供)
微軟提供了以下四種數據庫連接方式：
system.data.oledb.oledbconnection
system.data.sqlclient.sqlconnection
system.data.odbc.odbcconnection
system.data.oracleclient.oracleconnection
下面我們以范例的方式，來依次說明：
system.data.sqlclient.sqlconnection
常用的一些連接字符串(c#代碼)：
sqlconnection conn
= new sqlconnection( "server=(local);integrated security=sspi;database=pubs");
sqlconnection conn
= new sqlconnection("server=(local)//netsdk;database=pubs;integrated security=sspi");
sqlconnection conn = new sqlconnection(
"data source=localhost;integrated security=sspi;initial catalog=northwind;");
sqlconnection conn = new sqlconnection(
" data source=(local);initial catalog=xr;integrated security=sspi;
persist security info=false;workstation id=xurui;packet size=4096; ");
sqlconnection myconn = new
system.data.sqlclient.sqlconnection("persist security info=false;integrated
security=sspi;database=northwind;server=mysqlserver");
sqlconnection conn = new sqlconnection(
" uid=sa;pwd=passwords;initial catalog=pubs;data source=127.0.0.1;connect timeout=900");
更多字符串連接說明請看msdn：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp
system.data.oledb.oledbconnection
常用的一些連接字符串(c#代碼)：
oledbconnection conn = new oledbconnection(@"provider=microsoft.jet.oledb.4.0;data source=d:/myweb/81/05/grocertogo.mdb");
oledbconnection conn = new oledbconnection(
@"provider=microsoft.jet.oledb.4.0;password=;
user id=admin;data source=grocertogo.mdb;");
oledbconnection conn = new oledbconnection(
"provider=msdaora; data source=oracle8i7;persist security info=false;integrated security=yes");
oledbconnection conn = new oledbconnection(
"provider=microsoft.jet.oledb.4.0; data source=c:/bin/localaccess40.mdb");
oledbconnection conn = new oledbconnection(
"provider=sqloledb;data source=mysqlserver;integrated security=sspi");
更多字符串連接說明請看msdn：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassconnectionstringtopic.asp?frame=true
system.data.oracleclient.oracleconnection
常用的一些連接字符串(c#代碼)：
oracleconnection myconn = new system.data.oracleclient.oracleconnection(
"data source=oracle8i;integrated security=yes");
更多字符串連接說明請看msdn：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclientoracleconnectionclassconnectionstringtopic.asp?frame=true
system.data.odbc.odbcconnection
常用的一些連接字符串(c#代碼)：
odbcconnection conn = new odbcconnection(
"driver={sql server};server=myserver;trusted_connection=yes;database=northwind;");
odbcconnection conn = new odbcconnection(
"driver={microsoft odbc for oracle};server=oracle8i7;
persist security info=false;trusted_connection=yes");
odbcconnection conn = new odbcconnection(
"driver={microsoft access driver (*.mdb)};dbq=c:/bin/nwind.mdb");
odbcconnection conn = new odbcconnection(
"driver={microsoft excel driver (*.xls)};dbq=c:/bin/book1.xls");
odbcconnection conn = new odbcconnection(
"driver={microsoft text driver (*.txt; *.csv)};dbq=c:/bin");
odbcconnection conn = new odbcconnection("dsn=dsnname");
更多字符串連接說明請看msdn：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbcodbcconnectionclassconnectionstringtopic.asp?frame=true
其他廠商提供的數據庫連接：
db2connection myconn = new ibm.data.db2.db2connection(
"database = sample;uid=<username>; pwd=<password>;");
db2connection myconn = new ibm.data.db2.db2connection("database = sample");
bdpconnection myconn = new borland.data.provider.bdpconnection("assembly=borl
and.data.mssql,version=1.1.0.0,culture=neutral,publickeytoken=91d62ebb5b0d1b1b;ve
ndorclient=sqloledb.dll;osauthentication=false;database=<database>;usernam
e=<user>;hostname=<host>;password=<password>;provider=mssql");
bdpconnection myconn = new borland.data.provider.bdpconnection("assembly=borl
and.data.db2,version=1.1.0.0,culture=neutral,publickeytoken=91d62ebb5b0d1b1b;ve
ndorclient=db2cli.dll;database=<database>;username=<user>;
password=<password>;provider=db2");
connection pooling
在sql server、ole db和.net框架結構中的data provider中，都提供了隱式的連接池連接支持。你可以在connectionstring中指定不同的參數值控制連接池的行為。比如下面的例子使ole db的連接池無效并自動地進行事務處理：
provider=sqloledb;ole db services=-4;data source=localhost;integrated security=sspi;
在sql server.net data provider中提供了以下參數設置控制連接池的行為：connection lifttime、connection reset、enlist、max pool size、min pool size和pooling。
更多數據庫連接信息，以及非ado.net的連接字符串可以參看：
http://www.connectionstrings.com/
--轉載
