QAID # 14030 Published
Question / Problem:
I am trying to setup a relational database in Kofax Transformation Modules (KTM) 4.5 and 5.0. I am using a 64-bit OS, and have been able to set up a System DSN in the ODBC Data Source Administrator that tests successfully.
Why am I not able to see the System DSN in the relational database setup in the Database tab of the Project Settings for KTM Project Builder?
Answer / Solution:
There is a known issue reported where a database connection cannot be established for a 64-bit 'System DSN'.
The workaround for this is to use the 32-bit ODBC Data Source Administrator, which can be found at:
Set up the System DSN in the 32-bit ODBC Data Source Administrator, then go back and specify the DSN in the database connection setup for the relational database in KTM.