ODBC Connectivity Tips
This section provides information about ODBC connectivity tips.
Connecting to a Table
As a general rule, when connecting to a database with ODBC, most programs require that the database engine is up and running at the time the connection is attempted.
To connect to a table in the database with ODBC, start the integration platform, create a new data set, and follow the procedure for your connector.
ODBC Driver Setup Error
If you receive the error "Source connection information is missing," or if the Reselect DSN dialog box keeps appearing, do the following.
1. Delete the DriverOptions (leave blank).
2. Change ModifyDriverOptions to false.
3. Change DriverCompletion to No Prompt.
4. For TransactionIsolation, select Read Uncommitted.
5. Click Apply.