IGSS ODBC Access to Database not working

FAQ Question

I am running IGSS on 64 bit OS and I am trying to access the HDM database from my SQL server but I get no data and errors in IGSS event log. What is the issue?


You must use the ODBCad32.exe driver found in C:\Windows\SysWOW64. If you use the default ODBC driver for 64-bit applications, you will not be able to use ODBC functionality from IGSS.

The ODBCad32.exe file found in C:\Windows\SysWOW64 is used to run 32-bit applications (such as IGSS) on a 64-bit Windows operating system while the default ODBCad32.exe file found in Control Panel > Administrative Tools > Data Sources (ODBC) is used to run 64-bit applications on a 64-bit Windows operating system.

To ensure you have started the correct ODBCad32.exe file for 32-bit applications, you can open the Task Manager while the ODBC is running and click on the Processes tab. If the ODBCad32.exe process is suffixed with a “*32”, then the correct ODBC driver is running.

After configuring your ODBC, you must re-start the IGSS application.