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
