DataSourceOLEDBConnectionString
MicrosoftAccess
| Provider=Microsoft.Jet.OLEDB.4.0;DataSource=physicalpathto.mdbfile |
Microsoft SQL Server
| 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 |
SQL Server
| DRIVER={SQLServer}; SERVER=pathtoserver |
Oracle
| DRIVER={MicrosoftODBCforOracle}; SERVER=pathtoserver |
MicrosoftExcel
| Driver={MicrosoftExcelDriver(*.xls)}; DBQ=physicalpathto.xlsfile; DriverID=278 |
Microsoft Excel 97
| 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 |
Microsoft Visual FoxPro(with a database container)
| Driver={MicrosoftVisualFoxProDriver}; SourceType=DBC; SourceDb=physicalpathto.dbcfile |
Microsoft Visual FoxPro (without a database container)
| Driver={MicrosoftVisualFoxProDriver}; SourceType=DBF; SourceDb=physicalpathto.dbffile |
941
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
