ODBC link
Suitable for database types
Link method
Access "Driver = {Microsoft Access Driver (*. MDB)}; dbq = *. MDB; UID = Admin; PWD = pass;" DBASE "driver = {Microsoft DBase Driver (*. dbf)}; driverid = 277; DBQ = ------------; "Oracle" driver = {microsoft odbc for oracle}; server = oraclesever.world; uid = admin; pwd = pass; "MSSQL Server" driver = {SQL Server} ; server = servername; database = dbname; uid = sa; pwd = pass; "ms text" driver = {microsoft text driver = {microsoft text driver (*. txt; * .csv)}; dbq = -----; extensions = ASC, csv, tab, txt; Persist securityInfo = false; "Visual Foxpro" Driver = {microsoft Visual Foxpro driver}; sourcetype = DBC;. sourceDB = * dbc; Exclusive = No; "MySQL" Driver = {mysql}; database = yourdatabase UID = username; PWD = YourPassword; Option = 16386; "
OLEDB link
Suitable database type
Link method
access "Provider = microsoft.jet.oledb.4.0; data source = your_database_path; user id = admin; password = pass;" Oracle "Provider = OraOLEDB.Oracle; data source = dbname; user id = admin; password = pass;" MS SQL Server "Provider = SQLOLEDB; data source = machinename; initial catalog = dbname; userid = sa; password = pass;" MS text "Provider = microsof.jet.oledb.4.0; data source = your_path; Extended Properties'text; FMT = DELIMITED '"