I have a Visual Basic Program that connects ton an Informix Database. I can use Access 2000 to link to the tables through ODBC, but When I use Visual Basic 6.0 with and ADO Connection, Every Recordset I pull Returns no data. I have tried diffrent versions of Informix 7 to 7.3, and Using as DSN Connection and DSN-Less Connection. I have Tried Simple Queries, but none of these seem to work. Below is an Example of the code. Also, I am using MDAC 2.6.
Dim ADO_Rdst As New ADODB.Recordset
Dim ADO_Conn As New ADODB.Connection
Dim ADO_Comm As New ADODB.Command
Dim SQLString As String, rCount As Long, X As Integer
SQLString = "SELECT * From synonyms"
ADO_Conn.ConnectionString ="DRIVER=OpenLink Generic 32 Bit Driver; UID=UserID;PWD=UserPWD;NoLoginBox=Yes; FetchBufferSize=30;ReadOnly=Yes;Host=cmsIP;Protoco l=TCP/IP;ServerType=Informix 7.2;ServerOptions=;Options=;Database=;Server=OpenL ink"
.ActiveConnection = ADO_Conn
.CommandText = SQLString
.CommandType = adCmdText
.CursorType = adOpenForwardOnly
.CursorLocation = adUseClient
.LockType = adLockReadOnly