|
|
收集了ADO.NET下四种Provider的连接串写法，记下来方便查找：
SQLSERVER:
"undefinedersist Security Info=False;Integrated Security=SSPI;Initial Catalog=Northwind;server=(local)"
"Initial Catalog=Northwind;Data Source=(local);User ID=saundefinedassword=pwd"
ORACLE：
"Data Source=Oracle8i;user id=userid;password=pwd"
"Data Source=Oracle8i;Integrated Security=yes"
OLEDB：
"undefinedrovider=MSDAORA; Data Source=ORACLE8i7undefinedersist Security Info=False;Integrated Security=Yes"
"undefinedrovider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/bin/LocalAccess40.mdb"
"undefinedrovider=SQLOLEDB;Data Source=(local);Integrated Security=SSPI"
ODBC：
"Driver={SQL Server};Server=(local);Trusted_Connection=Yes;Database=AdventureWorks;"
"Driver={Microsoft ODBC for Oracle};Server=ORACLE8i7undefinedersist Security Info=False;Trusted_Connection=Yes"
"Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/bin/Northwind.mdb"
"Driver={Microsoft Excel Driver (*.xls)};DBQ=c:/bin/book1.xls"
"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:/bin"
"DSN=dsnname"
|
|
|EaBIM网
( 苏ICP备2020058923号-1 ) 
苏公网安备32011502011255号
IP卡
狗仔卡
发表于 2014-1-9 15:14:13
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
微信
收藏
转播
分享
淘帖
支持
反对
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
楼主
发表于 2014-3-31 17:13:48
发表于 2014-5-13 11:21:40
