If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

á
Go Back  dBforums > Database Server Software > Informix > ODBC 'Test connection was NOT successful'

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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??
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Posts: 6
CSDK VERSION:ibm informix client-sdk2.80
ODBC VERDION:3.520.4403.2(from ODBC ->ABOUT)

thanks!
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
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!!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On