Database EngineConnectionStringDBASE (using ODBC) Driver = {Microsoft dBASE Driver (* .dbf)}; DriverID = 277; Dbq = C: / path / to / databaseExcel (using ODBC) Driver = {Microsoft Excel Driver (* .xls)}; Driverid = 790; DBQ = C: / path / to / spreadsheet; defaultdir = c: / path / to / defaultdirexcel (use Ole DB) provider = microsoft.jet.Oledb.4.0; data source = C: / Path / TO / SHEET.XLS; Access (Using ODBC) Driver = {Microsoft Access Driver (* .mdb)}; DBQ = C: /Path/to/database.mdb; Uid = UserName; PWD = Password You Can Also Pass AdditionAl Options - For example, exclusive = 1; sets it to be opened in excel mode.access (use Ole DB) Using Standard Security Provider = Microsoft.jet.Oledb.4.0; Data Source = C: /Path/to/Database.mdb; user ID = username; Password = somepassword; Using Workgroup security str = "Provider = Microsoft.Jet.OLEDB.4.0; DataSource = database.mdb; JET OLEDB: System Database = mysystem.mdw;" oConn.Open (str, "my_user_name", "my_password") Firebirdremote Database Provider = 'lcpi.ibprovider'; data source = 'Remotehost: c: /path/to/database.fdb'; user ID = 'u sername '; Password =' pwd '; Auto Commit = true; The above is reported to work for a Firebird database by Edward Diamond (ediamond at water dot ca dot gov) I would presume that it could work on a local Firebird server,. . simply by removing "remotehost" from the string above Edward reports that even simple queries do not work without the "Auto Commit" part in the connection string.MySQL (using ODBC) Local Database Driver = {MySQL ODBC 3.51 Driver}; Server = localhost; user = username; password = mypassword; database = mydatabase; remote database driver =
