This section describes how to troubleshoot common problems that might occur when you set up the ODBC Connector.
If you use the 64-bit ODBC Connector, you must use a 64-bit ODBC driver. On Windows, define your data source in the 64-bit ODBC Data Source Administration utility.
If you install the 32-bit ODBC Connector on a 64-bit operating system, you must use a 32-bit ODBC driver. On Windows, define your data source in the 32-bit ODBC Data Source Administration utility. You can find this utility at C:\Windows\SysWOW64\odbcad32.exe
.
The ODBC Connector opens a new connection to retrieve data from each sub-table that you specify in the connector’s configuration file. However, some ODBC implementations limit the number of connections. If this occurs, you can set the configuration parameter UseSingleConnectionForSubtables
to true
. This ensures that the connector uses only one connection for retrieving data from sub-tables.
If the connector does not return the data you expect, use a SQL tool or interface to run the query that you entered in the connector’s configuration file. Check that the data returned matches what you want to retrieve. The connector cannot retrieve XML data types, but you can modify your SELECT statement to convert these data types into strings.
This is expected behavior. The information in the content field (specified by the ContentField
parameter) is used to populate the document content. If your content field contains a file path and you want to write the path to a document field, you can modify your SQL query to return the column under another name. For example:
SELECT myfield, myfield AS "anotherfield" FROM tablename...
Then, in your template file, specify the alternate name:
#DREFIELD MyFieldName="<!--anotherfield-->"
The connector might fail to retrieve BLOB data from an IBM DB2 database, and write the following message to the synchronize log:
Unsupported column data type
This is due to the data types returned by the IBM DB2 ODBC driver. To resolve this issue, set LongDataCompat=1
in the DB2 ODBC driver configuration file db2cli.ini
. This changes the types that are returned. For more information about this parameter, refer to the IBM DB2 documentation.
|