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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PN - 23 Feb 2006 04:20 GMT

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

Reply to this Message

Sheshnarayan Agrawal - 23 Feb 2006 05:29 GMT

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

Reply to this Message

PN - 23 Feb 2006 05:58 GMT

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

Reply to this Message

VG - 23 Feb 2006 14:56 GMT

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

Reply to this Message

PN - 23 Feb 2006 21:45 GMT

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

Reply to this Message