Topic
  • 2 replies
  • Latest Post - ‏2013-12-06T22:51:42Z by Sathyanesh
BigMikeAU
BigMikeAU
1 Post

Pinned topic Informix ODBC "Must close current database"

‏2013-11-04T04:08:04Z |

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.

  • fiedlerMPS
    fiedlerMPS
    1 Post

    Re: Informix ODBC "Must close current database"

    ‏2013-12-04T12:59:36Z  

    quit

  • Sathyanesh
    Sathyanesh
    17 Posts

    Re: Informix ODBC "Must close current database"

    ‏2013-12-06T22:51:42Z  

    Informix ODBC driver is not officially supported against SE; it may still work though.