Generic ODBC

The following versions of ODBC are supported

If you want to transfer data to/from ODBC Data Sources, you have to do the following:

Install ODBC driver for your database on the computer (if not already done).

Create a connection for each database that you want to transfer data to/from. You can create the connection in the "ODBC Administrator" via a "DSN" connection or by using an "ODBC driver" directly.

The fields of the Generic ODBC Data Source Card are as follows:

Description: Enter a text describing the Data Source.
ODBC Version: Specify which ODBC version you use. Choose between 2.0 DSN, 3.0 DSN, 2.0 driver or 3.0 driver.
Server Connect: Enter the DSN name or the full driver name here. You can also enter all the connection parameters in this field and then leave the next three fields empty - like: "Microsoft Access Driver (*.mdb);DBQ=C:\database\NORTHWIND.MDB"
Database: If a Data Source gets data from a local database or a server that is hosting multiple databases, it should be specified.
UserID: If the database needs a UserID you specify it here.
Password: If the database needs a Password you specify it here.