SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-09-28 12:22:17

mirchd
Member

How to fill the option

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

#2 2011-09-28 12:27:55

sqldbxhelp
Administrator

Re: How to fill the option

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

#3 2011-09-29 10:23:38

mirchd
Member

Re: How to fill the option

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

#4 2011-09-29 10:31:38

sqldbxhelp
Administrator

Re: How to fill the option

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

#5 2013-03-28 10:19:58

edowney
Member

Re: How to fill the option

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

#6 2013-03-28 10:38:23

sqldbxhelp
Administrator

Re: How to fill the option

Select DBMS Type ODBC.
Select DSN you have for Informix
Type User/password and press OK.
That should be enough

Offline

#7 2013-07-09 09:43:32

aangelo
Member

Re: How to fill the option

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

#8 2013-07-09 16:54:42

sqldbxhelp
Administrator

Re: How to fill the option

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

#9 2013-07-10 03:16:16

aangelo
Member

Re: How to fill the option

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

Board footer

Powered by FluxBB