Hi,

Thanks....I have CLI loaded on my work station - I attach to the INFORMIX
database with Crysal Reports v8.0 to create internal reports for management.

I am trying to write a simple program that will pull data from the INFORMIX
database and update an Access 2000 database.  I am able to create the ADO
and get the "connection succeeded" message when I test the connection.

I am attaching to an INFORMIX table called "ad" and am attempting to print
the contents of a field called "id_net_amt" to a simple text box for testing
purposes.  So, I've placed the following code in the "form activate" event
of a simple form that contains the ADO and the text box.  The following is
the code I am using:

Form1.Text1.Text = Adodc1.Recordset("id_net_amt")

But when it runs I get a database error.  What am I doing wrong....I really
appreciate your assistance.

Paul

----- Original Message -----
From: Hiap <svr4@m...>
To: professional vb <pro_vb@p...>
Sent: Wednesday, May 30, 2001 6:41 AM
Subject: [pro_vb] Re: Need help with Informix & VB ADO


> Hi Paul,
>
> To access Informix from VB you must do several things :
> - Install on the server Informix CLI for Informix DSA under NT, Informix
> Star for Informix Online 5 under Unix
> - Informix CLI must be installed on the Client side
> - Set DSN for the connection (using ODBC DAta Source Administrator)
> - Try connect from VB using this code :
>     cn.ConnectionString = "DSN=myinformix;UID=myid;PWD=mypwd;"
>     cn.Open
>
> Hope this can help.
>
> Hiap
>
> > Hi,
> >
> > I hope someone can help.  I am attempting to access an INFORMIX database
> 
> > via the VB v6.0 ADO and ODBC driver.  I am able to set the ADO Data Link
> 
> > Properties and am able to get the "Test Connection Succeeded" message 
> > box.  However, I am not having any luck when attempting to read data 
> > from a specific table.
> >
> > Does anyone out there know of a source of information that explains 
> > connecting and extracting data from INFORMIX?  Any and all help is 
> > greatly appreciated.
> >
> > Paul Esquinaldo
> >
>
>
>