Oninit cdi / Archive
Talk to an expert →

Latest OLEDB and ODBC version of IBM Informix SDK Client that supports SE 7.x

Posted in 2006

Topics: Connectivity: ODBC / JDBC / .NET

PN — — source: Usenet: comp.databases.informix

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

↪ replying to PN
Sheshnarayan Agrawal — — source: Usenet: comp.databases.informix

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

↪ replying to Sheshnarayan Agrawal
PN — — source: Usenet: comp.databases.informix

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

↪ replying to PN
VG — — source: Usenet: comp.databases.informix

I guess this has to do with named parameters in general with the Informix engine.

↪ replying to VG
PN — — source: Usenet: comp.databases.informix

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()

Related threads