Windows 7 ODBC to IDS 10.0 Server Issue

We have an environment where a variety of users connect to our IBM Informix Dynamic Server Version 10.00.FC4 databases (running on Solaris 10) via an ODBC connection. Our desktops Windows version has been XP for a long time and we have had no problems with ODBC setup and connectivity. Now, several users have had their desktops upgraded to Windows 7 (64bit) and the ODBC connection no longer works. We’ve tried to have them install several different, newer versions of CSDK, reboot, and recreate the ODBC connections, but so far without success. The Windows CSDK versions we have tried are clientsdk3.50.FC6.WIN, clientsdk3.50.TC9.WIN, and clientsdk3.70.FC4(understand IBM rolled back this version). The CSDK version on our IDS servers is 2.90.FC4. Has anyone else had similar issues? Any tips or recommendations for getting the ODBC working again? Thanks Much

And the error code is...? On Tue, Jan 10, 2012 at 12:01 AM, CYNTHIA SCOTT <clscott@klcorp.com> wrote: > We have an environment where a variety of users connect to our IBM Informix > Dynamic Server Version 10.00.FC4 databases (running on Solaris 10) via an > ODBC > connection. Our desktops Windows version has been XP for a long time and we > have had no problems with ODBC setup and connectivity. Now, several users > have > had their desktops upgraded to Windows 7 (64bit) and the ODBC connection no > longer works. We’ve tried to have them install several different, newer > versions of CSDK, reboot, and recreate the ODBC connections, but so far > without success. > > The Windows CSDK versions we have tried are clientsdk3.50.FC6.WIN, > clientsdk3.50.TC9.WIN, and clientsdk3.70.FC4(understand IBM rolled back > this > version). The CSDK version on our IDS servers is 2.90.FC4. > > Has anyone else had similar issues? Any tips or recommendations for getting > the ODBC working again? > > Thanks Much > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf3063e3373a634604b6217c5c

The only error was the text displayed after trying the Apply & Test Connection button: IBM Informix ODBC Error Message: Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix] Cannot connect to database server (grumpy). Thank You, Fernando, for pointing me in the right direction. My user got the connection working by installing the clientsdk.3.70.FC4DE.WIN (IBM Informix ODBC DRIVER (64-bit)) and changing the Host Name to a fully qualified name (instead of the server alias previously used in the old ODBC setup (grumpy).