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