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