SqlDbx
You are not logged in.
Pages: 1
I choose
DBMS Type:Informix
and I have a Informix Client . It is done.
The Setnet32 has been done .
but I don't know how to fill the sqldbx server login.
Please help...
Thank you.
Offline
This will work only in SqlDbx Professional edition
On login screen:
Server/Host: whatever name you set in setnet32
Database: informix database you connect to
User/password: your user and password
Offline
Thankyou Administrator.
I use a free edition.
When I fill something like yours, it returns a syntax error!
So I can use DBMS Type ODBC only.
But for Informix, ODBC always return some error messages(like -2001) even it returns a result rets for a query.
Offline
Yes. Free version supports only ODBC connection.
I am not sure what is error (-2001).
I can not find it, but it looks to me that it has something to do with different locale settings on client and server.
Offline
Ok, so I just downloaded the free version thinking I could use it to access my informix database. I have an ODBC defined on my PC and can connect to the database through it via .net software I write. So how do I use the free version with the ODBC?
Offline
Select DBMS Type ODBC.
Select DSN you have for Informix
Type User/password and press OK.
That should be enough
Offline
Hello!
My SqlDbx version is 3.61 Professional.
I connect to Informix with ODBC and it works fine except for some functionalities that are not working because of ODBC.
Today I tried to connect directly to Informix, but I get the following message:
Database locale information mismatch.
Invalid connection string attribute.
Invalid connection string attribute.
How can I solve that?
Do I need to specify something in "Options"?
Thank you
Offline
Are you using ANSI or UNICODE version of SqlDbx?
If you use ANSI version you can set CLIENT_LOCALE and DB_LOCALE in options field on login screen.
Check your ODBC connection Environment page for locale values.
It should look something like this
CLIENT_LOCALE=en_US.CP1252 DB_LOCALE=en_US.819
Offline
Hello!
How can I check which version is SqlDbx (ANSI or UNICODE )?
I run SqlDbx.exe that I suppose to be ANSI.
I tried to fill option field in the connection form with
CLIENT_LOCALE=en_US.CP1252 DB_LOCALE=it_IT.1252
(like my ODBC settings), but I get the message:
Unable to load locale categories.
Invalid connection string attribute.
Invalid connection string attribute.
#############
SOLVED:
I only need
DB_LOCALE=it_IT.1252
Last edited by aangelo (2013-07-10 03:36:02)
Offline
Pages: 1