Data Source OLE DB Connection String
Microsoft Access
| Provider=Microsoft.Jet.OLEDB.4.0;Data Source=physical path to .mdb file |
Microsoft SQL Server
Provider=SQLOLEDB.1;
Data Source=path to database on server |
Oracle
Provider=MSDAORA.1;
Data Source=path to database on server |
Microsoft
Provider=MSIDXS.1;
Data Source=path to file Indexing Service |
Data Source Driver ODBC Connection String
Microsoft Access
Driver={Microsoft Access Driver (*.mdb)} ;
DBQ=physical path to .mdb file |
SQL Server
DRIVER={SQL Server};
SERVER=path to server |
Oracle
DRIVER={Microsoft ODBC for Oracle};
SERVER=path to server |
Microsoft Excel
Driver={Microsoft Excel Driver (*.xls)};
DBQ=physical path to .xls file;
DriverID=278 |
Microsoft Excel 97
Driver={Microsoft Excel Driver (*.xls)};
DBQ=physical path to .xls file;
DriverID=790 |
Paradox
Driver={Microsoft Paradox Driver (*.db )};
DBQ=physical path to .db file;
DriverID=26 |
Text
Driver={Microsoft Text Driver (*.txt;*.csv)};
DefaultDir=physical path to .txt file |
Microsoft Visual FoxPro(with a database container)
Driver={Microsoft Visual FoxPro Driver};
SourceType=DBC;
SourceDb=physical path to .dbc file |
Microsoft Visual FoxPro (without a database container)
Driver={Microsoft Visual FoxPro Driver};
SourceType=DBF;
SourceDb=physical path to .dbf file |