ado连接数据库字符串大全.docx
- 文档编号:24517529
- 上传时间:2023-05-28
- 格式:DOCX
- 页数:22
- 大小:21.53KB
ado连接数据库字符串大全.docx
《ado连接数据库字符串大全.docx》由会员分享,可在线阅读,更多相关《ado连接数据库字符串大全.docx(22页珍藏版)》请在冰豆网上搜索。
ado连接数据库字符串大全
ado连接数据库字符串大全
odbcdsnconnections3
odbcdsn-lessconnections4
odbcdriverforas/4004
odbcdriverforaccess4
odbcdriverfordbase4
odbcdriverforexcel5
odbcdriverformysql(viamyodbc)5
odbcdriverfororacle5
odbcdriverforparadox6
odbcdriverforsqlserver6
odbcdriverforsybase6
odbcdriverforsybasesqlanywhere7
odbcdriverforteradata7
odbcdriverfortext7
odbcdriverforvisualfoxpro7
oledbdatalinkconnections8
oledbproviderconnections8
oledbproviderforas/4008
oledbproviderforactivedirectoryservice8
oledbproviderfordb29
oledbproviderforindexserver9
oledbproviderforinternetpublishing9
oledbproviderformicrosoftjet9
excel10
text10
oledbproviderforodbcdatabases11
foraccess(jet):
11
forsqlserver:
11
oledbproviderfororacle(frommicrosoft)11
oledbproviderfororacle(fromoracle)11
oledbproviderforsimpleprovider12
oledbproviderforsqlserver12
remotedataservice(rds)connections13
rdsdatacontrol-connectproperty13
rdsdatacontrol-urlproperty14
adourlconnections14
msremoteproviderconnections15
msremote-access(jet)15
msremote-sqlserver16
datashapeproviderconnections17
.netmanagedproviderconnections17
sqlclient.netmanagedprovider17
withthe"sqlserveroledbprovider"(sqloledb).17
oledb.netmanagedprovider(system.data.oledb)18
odbc.netmanagedprovider(system.data.odbc)18
thispagecontainssampleadoconnectionstringsforodbcdsn/dsn-less,oledbproviders,remotedataservices(rds),msremote,msdatashape.alsoincludedareconnectionstringsforeach.netmanagedprovider(sqlclient,oledb,andodbc).thesesampleconnectionstringsarecompiledbycarlprothman,amicrosoftvisualbasicmvp.
tableofcontents
odbcdsnconnectionsdsn,filedsn
odbcdsn-lessconnections
odbcdriverforas/400
odbcdriverforaccess
odbcdriverfordbase
odbcdriverforexcel
odbcdriverformysql
odbcdriverfororacle
odbcdriverforparadox
odbcdriverforsqlserver
odbcdriverforsybase
odbcdriverforsybasesqlanywhere
odbcdriverfortext
odbcdriverforteradata
odbcdriverforvisualfoxpro
oledbdatalinkconnectionsdatalinkfile(udl)
oledbdataproviderconnections oledbproviderforas/400
oledbproviderforactivedirectoryservice
oledbproviderfordb2
olddbproviderforinternetpublishing
oledbproviderforindexserver
oledbproviderformicrosoftjet
oledbproviderforodbcdatabases
oledbproviderfororacle(frommicrosoft)
oledbproviderfororacle(fromoracle)
oledbproviderforsimpleprovider
oledbproviderforsqlserver
remotedataservice(rds)connectionsrdsdatacontrol-connectproperty
rdsdatacontrol-urlproperty
adourlconnectionsadorecordset
msremoteproviderconnectionsmsremote-access(jet)
msremote-sqlserver
datashapeproviderconnections msdatashape-sqlserver
.netmanagedproviderconnectionssqlclient.netmanagedprovider(system.data.sqlclient)
oledb.netmanagedprovider(system.data.oledb)
odbc.netmanagedprovider(system.data.odbc)
odbcdsnconnections
usinganodbcdsn(datasourcename)isatwostepprocess.
1)youmustfirstcreatethedsnviathe"odbcdatasourceadministrator"programfoundinyourcomputer""""""""scontrolpanel(oradministrativetoolsmenuinwindows2000).makesuretocreateasystemdsn(notauserdsn)whenusingasp.
note:
youcanalsocreatethedsnviavbcode.
2)thenusethefollowingconnectionstring-withyourowndsnnameofcourse. ;-)
odbc-dsn
oconn.open"dsn=advworks;uid=admin;pwd=;
youcanalsocreateanduseafiledsn.thenusethefollowingadoconnectionstring:
odbc-filedsn
oconn.open"filedsn=c:
\somepath\mydb.dsn;uid=admin;pwd=;"
formoreinformation,see:
aboutodbcdatasourcesandhowtousefiledsnsanddsn-lessconnections
note:
theproblemwithdsnisthatuserscan(andwill)modifythem(ordeletebymistake),
thenyourprogramwon""""""""tworksowell...soit""""""""sbettertouseadsn-lessoroledbprovider
connectionstringwithatrustedconnectionifpossible!
odbcdsn-lessconnections
odbcdriverforas/400
oconn.open"driver={clientaccessodbcdriver(32-bit)};system=myas400;uid=myusername;pwd=mypassword;"
formoreinformation,see:
afastpathtoas/400client/server
odbcdriverforaccess
forstandardsecurity:
oconn.open"driver={microsoftaccessdriver(*.mdb)};dbq=c:
\somepath\mydb.mdb;uid=admin;pwd=;"
ifyouareusingaworkgroup(systemdatabase):
oconn.open"driver={microsoftaccessdriver(*.mdb)};dbq=c:
\somepath\mydb.mdb;systemdb=c:
\somepath\mydb.mdw;admin",""
ifmdbislocatedonanetworkshare:
oconn.open"driver={microsoftaccessdriver(*.mdb)};dbq=\\myserver\myshare\mypath\mydb.mdb;"
formoreinformation,see:
microsoftaccessdriverprogrammingconsiderations
odbcdriverfordbase
oconn.open"driver={microsoftdbasedriver(*.dbf)};driverid=277;dbq=c:
\somepath;"
note:
specifythefilenameinthesqlstatement.forexample:
ors.open"select*fromuser.dbf",oconn,,,adcmdtext
note:
mdac2.1(orgreater)requirestheborlanddatabaseengine(bde)toupdatedbasedbffiles.(q238431).formoreinformation,see:
dbasedriverprogrammingconsiderations
odbcdriverforexcel
oconn.open"driver={microsoftexceldriver(*.xls)};driverid=790;dbq=c:
\somepath\myspreadsheet.xls;defaultdir=c:
\somepath;"
formoreinformation,see:
microsoftexceldriverprogrammingconsiderations
odbcdriverformysql(viamyodbc)
toconnecttoalocaldatabase
oconn.open"driver={mysql};server=myservername;option=16834;database=mydb;"
toconnecttoaremotedatabase
oconn.open"driver={mysql};server=;port=3306;option=131072;stmt=;database=mydb;uid=myusername;pwd=mypassword;"
formoreinformation,see:
programsknowntoworkwithmyodbc
odbcdriverfororacle
forthecurrentoracleodbcdriverfrommicrosoft:
oconn.open"driver={microsoftodbcfororacle};server=oracleserver.world;uid=myusername;pwd=mypassword;"
fortheolderoracleodbcdriverfrommicrosoft:
oconn.open"driver={microsoftodbcdriverfororacle};connectstring=oracleserver.world;uid=myusername;pwd=mypassword;"
formoreinformation,see:
connectionstringformatandattributes
odbcdriverforparadox
oconn.open"driver={microsoftparadoxdriver(*.db)};driverid=538;fil=paradox5.x;defaultdir=c:
\dbpath\;dbq=c:
\dbpath\;collatingsequence=ascii;"
note:
mdac2.1(orgreater)requirestheborlanddatabaseengine(bde)toupdateparadoxisamfdbffiles.(q230126).
formoreinformation,see:
paradoxdriverprogrammingconsiderations
odbcdriverforsqlserver
forstandardsecurity:
oconn.open"driver={sqlserver};server=myservername;database=mydatabasename;uid=myusername;pwd=mypassword;"
fortrustedconnectionsecurity:
oconn.open"driver={sqlserver};server=myservername;database=mydatabasename;uid=;pwd=;"
或者
oconn.open"driver={sqlserver};server=myservername;database=mydatabasename;trusted_connection=yes;"
topromptuserforusernameandpassword
oconn.properties("prompt")=adpromptalways
oconn.open"driver={sqlserver};server=myservername;database=mydatabasename;"
formoreinformation,see:
sqldriverconnect(odbc)
odbcdriverforsybase
ifusingthesybasesystem11odbcdriver:
oconn.open"driver={sybasesystem11};srvr=myservername;uid=myusername;pwd=mypassword;"
ifusingtheintersolv3.10sybaseodbcdriver:
oconn.open"driver={intersolv3.1032-bitsybase};srvr=myservername;uid=myusername;pwd=mypassword;"
formoreinformation,see:
sybasesystem10odbcdriverreferenceguide
odbcdriverforsybasesqlanywhere
oconn.open"odbc;driver=sybasesqlanywhere5.0;defaultdir=c:
\dbpath\;dbf=c:
\sqlany50\mydb.db;uid=myusername;pwd=mypassword;"
note:
includingthedsntagwithanullstringisabsolutelycriticalorelseyougetthedreaded-7778error.
formoreinformation,see:
sybasesqlanywhereuserguide
odbcdriverforteradata
oconn.open"provider=teradata;dbcname=mydbcname;database=mydatabasename;uid=myusername;pwd=mypassword;"
formoreinformation,seeteradataodbcdriver
odbcdriverfortext
oconn.open"driver={microsofttextdriver(*.txt;*.csv)};dbq=c:
\somepath\;extensions=asc,csv,tab,txt;persistsecurityinfo=false"
note:
specifythefilenameinthesqlstatement.forexample:
ors.open"select*fromcustomer.csv",oconn,adopenstatic,adlockreadonly,adcmdtext
formoreinformation,see:
textfiledriverprogrammingconsiderations
odbcdriverforvisualfoxpro
withadatabasecontainer:
oconn.open"driver={microsoftvisualfoxprodriver};sourcetype=dbc;sourcedb=c:
\somepath\mysourcedb.dbc;exclusive=no;"
withoutadatabasecontainer(freetabledirectory):
oconn.open"driver={microsoftvisualfoxprodriver};sourcetype=dbf;sourcedb=c:
\somepath\mysourcedbfolder;exclusive=no;"
formoreinformation,see:
visualfoxproodbcdriverandq165492
oledbdatalinkconnections
datalinkfile(udl)
forabsolutepath:
oconn.open"filename=c:
\somepath\mydatabasename.udl;"
forrelativepath:
oconn.open"filename=mydatabasename.udl;"
formoreinformation,see:
howto:
usedatalinkfileswithado
note:
windows2000nolongercontainsthe"new|microsoftdatalink"menuanymore.youcanaddthedatalinkmenubackinthemenulistbyrunningthe"c:
\programfiles\commonfiles\system\oledb\newudl.reg"regfile,thenright-clickonthedesktopandselect"new|microsoftdatalink"menu.oryoucanalsocreateadatalinkfilebycreatingatextfileandchangeit"sfileextensionto".
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ado 连接 数据库 字符串 大全