Hi there any Informix ODBC experts,
Need your help here.
I was configuring the datasource using above when I had
this error when i try to save the configuration.

"Could not open the registry"

Try to fill INFORMIXSQLHOST=<machine> environment variable

Marcelo E.

Thanks Marcelo.
I have now solved the problem and is able to connect to the database.
I could now see the tables after the connection.
However when I execute the VB programs, I get an error
"Informix ODBC Driver-No SELECT permission"
It also has this message
"Method 'Refresh of object IAdodc' failed.
Following is the VB code:
---------------------------------
Private Sub disp_Click()

adodc1.RecordSource = "select t_suno, t_nama, t_namb from baan.ttccom020800 where t_suno >= " & Trim$(rm1.Text) & " and t_suno <= " & Trim$(rm2.Text)

adodc1.Refresh


Set DataGrid1.DataSource = adodc1

End Sub
---------------------------------------------------------------------
I am using VB6 and Informix 7.3 and SDK2.81 for access.

What is this error???
Thanks and best regards,

ks wong

Hi,

If you have some tool to view the data like dbaccess, try to put your SELECT statement in this and run, if you get a same error then give GRANT permissions to user:

GRANT CONNECT TO PUBLIC

Marcelo E.

Hi Marcelo,
Thanks again for the idea, we have change the user to informix
and the program does not show the error anymore. However
no data are returned.
When I use Visdata in VB6 to open the ODBC, I have this error
ODBC - called failed, Number 3146
Pls help.

Hi,

ODBC - called failed, Number 3146

It is not an informix error message, I don't have VB error message guide, Question: your statement work in dbaccess ?

Don´t forget that all table and field names must be in lower case.

Marcelo E.