Latest OLEDB and ODBC version of IBM Informix SDK Client that supports SE 7.x
PN, running Informix SE 7.2 with .NET, asked for the latest SDK/OLEDB/ODBC supporting it. Sheshnarayan Agrawal said CSDK 2.90.xC4 was latest. PN listed limitations of the 3.82 ODBC driver: fields only by number, no rs.movelast, and a loop returning only one row. VG linked named parameters to the engine. No solution given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
We're running Informix SE 7.2. What's the latest version of client SDK that supports this standard engine version? Also, is there any other 3rd-party drivers out there that I can use? I'm using .NET 2003 and 2005 . The current ODBC driver has lots of limitations. thanks PN
The latest version of CSDK available is 2.90.xC4. What version of ODBC version are you using currently? Please can you describe the limitations you are talking about in ODBC driver? http://www-306.ibm.com/software/data/informix/tools/csdk/ Thanks & Regards -Shesh "PN" <ndphung@gmail.com> Sent by: informix-list-bounces@iiug.org 02/23/2006 09:50 AM To informix-list@iiug.org cc Subject Latest OLEDB and ODBC version of IBM Informix SDK Client that supports SE 7.x We're running Informix SE 7.2. What's the latest version of client SDK that supports this standard engine version? Also, is there any other 3rd-party drivers out there that I can use? I'm using .NET 2003 and 2005 . The current ODBC driver has lots of limitations. thanks PN _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
I'm runing 3.82 ODBC driver. One of the limitations is that you have to use the field # instead of field name. For example, rs.item(1).Value instead rs.item("fieldname").value Thanks PN
I guess this has to do with named parameters in general with the Informix engine.
This is another limitation: I can't use rs.movelast because the recordset using ODBC does not allow feeding backward. I cannot use a regular SQL SELECT statement to get all the rows in a table. Using a loop, I can only get 1 row for the connection. Do I have to use stored procedure to pull data from Informix SE 7.x? Is there anything else I could do to get SELECT work? Thanks PN Example:: Dim sconnect As String sconnect = "" ..... cnBol.ConnectionString = sconnect Try cnBol.Open() cmdBOL.ActiveConnection = cnBol cmdBOL.CommandText = "select * from vw_customer" cmdBOL.CommandType = ADODB.CommandTypeEnum.adCmdText rstFactor.Open(cmdBOL) ' rstFactor.MoveLast() MsgBox(rstFactor.RecordCount) rstFactor.MoveFirst()