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.
Returning Data Types
Some connectors (such as ODBC or connectors that support custom fields) returns a full set of data types only when a session is established with the database or application. In addition, you will either get valid (not necessarily correct, but valid) data types when you copy the fields, or if the connector supports user-defined data types, they will be changed to valid types after the connection is established.