Results 1 to 12 of 12
  1. #1
    Join Date
    Feb 2003
    Location
    Madrid
    Posts
    6

    ODBC 'Test connection was NOT successful'

    I have a problem with the ODBC driver version 3.81 32 bit
    when I want to connect with the DB in the server. I get this message 'Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Unable to load locale categories.'
    Best regards

  2. #2
    Join Date
    Feb 2003
    Posts
    60
    Can you edit the $INFORMIXDIR/etc/.snfile file, and check that the mandatory product installation order has been respected :

    a) development tools
    b) database engine
    c) network tools

  3. #3
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Hi

    Typically, this error occurs when you don't have an INFORMIXDIR set in your setnet32 or as environment variable.

    Emmon

  4. #4
    Join Date
    Jan 2003
    Posts
    6
    i have this problem too .but i have set the INFORMIXDIR.In win2000 pro OS that was successful,and in win98 OS the connect was fail,the same configuration in this two OS.
    why??

  5. #5
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi, are you able to connect to the server with the ilogin demo, provided by informix from the win98 machine?
    rws

  6. #6
    Join Date
    Jan 2003
    Posts
    6
    YES ĢŽI CAN use the Ilogin Demo connect to the sever,but ODBC CAN'T from the win98 machine

  7. #7
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Can you tell me what the exact version is of the CSDK and of the ODBC driver?
    rws

  8. #8
    Join Date
    Jan 2003
    Posts
    6
    CSDK VERSION:ibm informix client-sdk2.80
    ODBC VERDION:3.520.4403.2(from ODBC ->ABOUT)

    thanks!

  9. #9
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I don't see any immediate issues with these versions.
    Are you sure the ilogin demo works and is able to connect without displaying any error?
    You could always set ODBC tracing on. Just to see what error is returned.
    rws

  10. #10
    Join Date
    Jan 2003
    Posts
    6
    I sure the ilogin demo works and is able to connect without displaying any error

    The odbc error message is :
    Test connection was NOT successful,[informix][informix ODBC Driver] Unable to load translation DLL.
    I have test ODBC in two win98 machines and the error message was same!

  11. #11
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    This is an explanation of the error:

    An invalid locale name was supplied for the locale initialization. The
    environment variable to specify the locale category has a wrong value. Check the value of the corresponding environment variable, CLIENT_LOCALE or DB_LOCALE.
    Also check if INFORMIXDIR points to a valid directory where Informix products
    are installed.

    If a client application receives this error when it requests a database server
    connection, check that the client and database locales are compatible. They are

    compatible if a valid locale exists on the server computer with the name lg_tr.
    codeset@mod, where lg_tr (language and territory) and mod (locale modifier) are

    from the CLIENT_LOCALE and codeset is from the database locale (from the
    DB_LOCALE, if it is set, or as stored in the database).

    Okay, i have checked our knowledgebase which bought back many cases with
    similar issues. Things to check -

    - Check that INFORMIXDIR and PATH have been set correctly.
    - Check where the I-Connect has been installed i.e in program files, separate
    Informix dir, etc etc. Really, it should be installed (using custom
    installation) under c:\informixdir as I-Connect sometimes complains about being
    installed under program files..Please don't forget to uninstall any previous
    versions before installing.
    - Check Locales CLIENT_LOCALE=
    - in database : en_us.8859-1
    - in client: en_US.CP1252
    rws

  12. #12
    Join Date
    Jan 2003
    Posts
    6
    YES,that's ok!

    I MODIFY the "PATH=C:\PROGRAM FILES\INFORMIX\CLIENT-SDK\BIN " TO " PATH=C:\PROGRA~1\INFORMIX\CLIENT~1\BIN" IN AUTOEXEC.BAT ,THEN TEST SUCCESSFUL!


    THANKS roelwe!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •