Unanswered: ODBC 'test connection was not successful'
hi all -
i have a Win2K server i set up last year and it successfully connects to my unix-based Informix SE 7.3 server using the Informix 3.81 32 bit driver (from the CSDK 2.80...3.81.0000 2.80.TC1, or 3.81.00.11267, depending on which screen you're on).
i set up another Win2K machine this week thinking this would be a snap, and no matter what i do, I can't successfully test the driver via the Windows ODBC System DSN configurator.
the new machine has TCP/IP connectivity to the server and the CSDK 2.80 DBPING and iLogin tools connect successfully to the DB.
here are the environment variables set in setnet32:
/* this is exactly how it is in the working machine */
/*on my other machine, it works with INFORMIXDIR=C:\Program Files\Informix\Client-SDK....on this machine, i've tried both...also with \bin at the end*/
/* this is exactly the same as the working machine */
when i try to apply and test the connection, i get: test connection was NOT successful...unable to load translation DLL.
when i hit the apply button, i get: The displayed locale and codeset have not been found on the client machine. Using these locale/codeset will result in -23101 Unable to load locale categories error message. Please install the locales.
i have also downloaded and installed the latest and greatest CSDK 2.81 (3.81.0000 2.81.TC3) and everything described above still happens.
for reference, something similar happened to a dbforum poster last year using win98. the solution was to edit the path in autoexec.bat...which won't work for me since Win2K has no autoexec.bat. see: http://www.dbforums.com/t694408.html.