I am trying to setup a Data Source from Windows 7 to a Linux base Informix SE (7.32.UC4) Database.
I am using the 32-bit version of ODBC Data Source Administrator (...\SysWOW64\odbcad32.exe).
I constantly get "Must close current database before using a new database." when I test the connection.
I have edited ../informix/etc/sqlhosts, /etc/services and am using the correct port. The available databases appear in the dropdown list, so I am connecting to the remote server fine. However, they do each appear twice!
When I select "Apply & Test Connection", I get this error message: Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Must close current database before using a new database.
if I select a listed DB, or even if I type a name that does not exist (for testing purposes), same result.
sqlexec is running.
Note that I have tried this on XP as well, same result. I have also tried various versions of the ClientSDK, same result.