IGSS ODBC Access to Database not working.
I am running IGSS on 64 bit OS and I am trying to access the HDM database from my SQLserver but I get no data and errors in IGSS event log.
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.