Informix / OpenLinkODBC / VB5.0 / SQLExtendedFetch

Posted in 1997

Bill Bertovich — Mon, 9 Jun 1997 20:11:14 -0700 — source: Informix-list mailing list archive (1991-1998)

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). C ode: <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