常见连接数据库字符串

DataSourceOLEDBConnectionString
MicrosoftAccess

Provider=Microsoft.Jet.OLEDB.4.0;DataSource=physicalpathto.mdbfile

MicrosoftSQLServer

Provider=SQLOLEDB.1; DataSource=pathtodatabaseonserver

Oracle

Provider=MSDAORA.1; DataSource=pathtodatabaseonserver

Microsoft

Provider=MSIDXS.1; DataSource=pathtofileIndexingService

DataSourceDriverODBCConnectionString
MicrosoftAccess

Driver={MicrosoftAccessDriver(*.mdb)}; DBQ=physicalpathto.mdbfile

SQLServer

DRIVER={SQLServer}; SERVER=pathtoserver

Oracle

DRIVER={MicrosoftODBCforOracle}; SERVER=pathtoserver

MicrosoftExcel

Driver={MicrosoftExcelDriver(*.xls)}; DBQ=physicalpathto.xlsfile; DriverID=278

MicrosoftExcel97

Driver={MicrosoftExcelDriver(*.xls)}; DBQ=physicalpathto.xlsfile; DriverID=790

Paradox

Driver={MicrosoftParadoxDriver(*.db)}; DBQ=physicalpathto.dbfile; DriverID=26

Text

Driver={MicrosoftTextDriver(*.txt;*.csv)}; DefaultDir=physicalpathto.txtfile

MicrosoftVisualFoxPro(withadatabasecontainer)

Driver={MicrosoftVisualFoxProDriver}; SourceType=DBC; SourceDb=physicalpathto.dbcfile

MicrosoftVisualFoxPro(withoutadatabasecontainer)

Driver={MicrosoftVisualFoxProDriver}; SourceType=DBF; SourceDb=physicalpathto.dbffile