Skip to main content
Kofax

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

14030

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:

C:\WINDOWS\SysWOW64\odbcad32.exe.

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.

Applies to:

Product Version Category
AXPRO 4.5 Project Builder
AXPRO 5.0 Project Builder