I’m developing program in Visual Basic conecting Universe by
ADODB connection . I not got the connection and I need some
sample to continue my project.
IBM and Informix doesn't help me this way . I really need some help, because I don’t
know what else I can do , it’s very dificulty to understant
without sample.
PLEASE, HELP ME

Thank you for all

Scipione.

You can try this, I successfully create connetion from VB to Informix.
Using the following connection codes:

This is use to establish the connection.
Set rdoCon = New rdoConnection
With rdoCon
.Connect = "DSN=odbcname;uid=username;pwd=password"
.LoginTimeout = 14400
.EstablishConnection rdDriverNoPrompt
End With

This is how I use to get/query data from Informix
strSQL = "select * from table where id = '" & txtid.Text & "'"
Set rdoRes = rdoCon.OpenResultset(strSQL)
If rdoRes.EOF Then
MsgBox ("Invalid Login! Please Try Again!")
Else
row_count = rdoRes.RowCount
End If
After the rdoRes executed, you can use the rdoRes(#) to refer to the field.

tn5353,

In fact I´ve tried to do this but I couldn´t get successfull... I don´t know what happens. Could I send my project for you in order you take a look and help me???

Thanks a lot!!!

Scipione.

Yes, you can!

I am trying to import some data into sql server from unidata rdbms on a unix machine. Can you pass on some info of how to do this one.
Please

I was trying to connect to unidata rdbms by using unidata odbc driver but for some reason this driver is not able to recognize sql complaint unidata tables.
Please throw some light on this

Thank You
Krishna