Re: Informix / OpenLinkODBC / VB5.0 / SQLExtendedFetch

>Hi all, >Having a problem Connecting to Informix 7.1x using OpenLink 1.0 32 bit ODBC drivers from Visual Basic 5.0. I am using RDO objects and methods. It seems as >though OpenLink doesn't support theSQLExtendedFetch command (at least that's what Dr. Dee Bee says). >Code: ><in the general declarations section of a form> >Option Explicit >Dim Env As rdoEnvironment >Dim Cn As rdoConnection ><later on in a private sub on the same form> >Dim Rst as rdoResultset >Set Rst = Cn.OpenResultset(txtSQL.Text, rdOpenStatic, rdConcurLock) ><where txtSQL.Text is a valid SQL command> >I get the error message: >Run-time error '4002' >IM0001: [Microsoft] [ODBC Driver Manager] Driver does not support this function. >This same routine works with Oracle, MS SQL Server and Sybase SQL Anywhere (all with different ODBC drivers), but not on Informix with OpenLink. Anyone out >there who has solved this problem (other than using DAO). >Thanks, >Bill Why don't you try using Informix CLI 2.5 instead of OpenLink 1.0. It's a no-charge ODBC driver that comes with your 7.2x Online engine. If you're using less than 7.2x then there might be a charge. We have used CLI with VB4 and are just starting to use VB5. We've had some troubles, though. VB5 delivers new ODBC Driver Manager DLLs, version 3.0 and we've had trouble getting these to work. We use NT 4.0 and Service Pack three also delivers new ODBC Driver Manager DLLs. These seem to work much better. We're using RDO 2.0 in Visual Basic 5. Bruce Farwell Spartan Stores, Inc. Grand Rapids, MI