作者　: wqch88
標(biāo)題　: 各種數(shù)據(jù)庫的ado連接字符串
關(guān)鍵字: 連接字符串
分類　: 開發(fā)技巧
密級　: 公開
(評分: , 回復(fù): 0, 閱讀: 2886) »»
1.Oracle:
 a>先設(shè)置好Oracle本地服務(wù)名配置,如:USER_DB
 b>配置ODBC引擎:ODBC_DB,該引擎的服務(wù)器指向Oracle的本地服務(wù)名,即:USER_DB
 c>配置聯(lián)接字符串,如:Provider=MSDASQL.1;Password=user;Persist Security Info=True;User ID=user;Data Source=ODBC_DB;Extended Properties="DSN=ODBC_DB;UID=user;PWD=user;SERVER=USER_DB;"
2.Access
 聯(lián)接字符串:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\aa.mdb;Jet OLEDB:Database password=123
3.DBF(Dbase數(shù)據(jù)庫)
 聯(lián)接字符串:Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\DBF\;Mode=Share Deny None;Extended Properties=DBase 5.0
4.Excel
 聯(lián)接字符串:Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=F:\Excel\demo.xls;Mode=Share Deny None;Extended Properties=Excel 8.0;
5.TEXT
 聯(lián)接字符串:Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=D:\txt;Mode=Share Deny None;Extended Properties="text;HDR=YES;FMT=Delimited"
6.DBF(Visual Foxpro數(shù)據(jù)庫)
 聯(lián)接字符串:Provider=MSDASQL;Persist Security Info=False;Extended Properties="DSN=Visual FoxPro Tables;UID=;SourceDB=D:\DBF\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
7.db(Paradox7.0)
聯(lián)接字符串:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Borland\Borland Shared\Data;Mode=Share Deny None;Extended Properties=paradox 7.x