Informix and ADO support and ADO->ODBC->Informix error
John Leerentveld asked whether IDS supports ADO directly and reported the error 'Optional feature not implemented' via ADO to the Intersolv ODBC driver. He later found the fix: use the Intersolv 3.x ODBC driver instead of Informix 2.8 and add NLB=true to the connection string. Bashar Chalabi added that Informix ODBC 3.3 in the latest client SDK supports ADO directly.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, Does Informix IDS support directly access through ADO? If yes, where can I get a driver? II no, I presume the second best is ADO->Connect to ODBC -> Intersolv ODBC-driver But using this combinating (both for VB 6 ans C++) we get the error: '[Intersovl][ODBC Informix driver] Optional feature not implemented' How to avoid that error? Thanks, John Leerentveld<jl@ibt.nl>
The solution for the ADO -> OLE DB error is found: Use Intersolv 3.x ODBC-driver instead of Informix 2.8 Add Attribute, or Connection String 'NLB=true' John Leerentveld<jl@ibt.nl>
FYI - There is a new Discussion List for Informix Jobs and Help at the following URL http://consultantpage.netfirms.com/ @@ Richard Sent via Deja.com http://www.deja.com/ Before you buy.
ADO is supported directly by Informix ODBC 3.3 (available in the latest client SDK). -- Bashar Chalabi CTL, London