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
PLEASE, HELP ME
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
.Connect = "DSN=odbcname;uid=username;pwd=password"
.LoginTimeout = 14400
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!")
row_count = rdoRes.RowCount
After the rdoRes executed, you can use the rdoRes(#) to refer to the field.