Thread: help - psqlODBC with V5

help - psqlODBC with V5

From
"Robson Martins"
Date:
 I'am usage VB 5.0 with PostgrSQL  7.1.3 and postODBC driver 7.2.1, while use psqlODBC driver 7.01.0009, not error,
because?
 
Message erros is:
 
Erro 40008 - Invalid operation for forward-only cursor ( error, only version driver psqlODBC 7.2.1)
 
thank's.
 
 
Robson Martins
from Brazil
 

Re: help - psqlODBC with V5

From
"Corey W. Gibbs"
Date:
Howdy Robson,

I think you want to try the adOpenKeyset option on the recordset object.
 That lets you go forward and backwards in the recordset.  I went around
and around with this for a while.  Hope this helps
corey


dim rs as new adodbc.recordset
set rs = new adodbc.recordset
rs.Open "SELECT * from foo WHERE bar='VBisFun:P'", cn, adOpenKeyset,
adLockOptimistic


-----Original Message-----
From:    Robson Martins [SMTP:robson-martins@bol.com.br]
Sent:    Thursday, June 13, 2002 7:52 AM
To:    pgsql-odbc@postgresql.org
Subject:    [ODBC] help - psqlODBC with V5

 I'am usage VB 5.0 with PostgrSQL  7.1.3 and postODBC driver 7.2.1, while
use psqlODBC driver 7.01.0009, not error,
because?

Message erros is:

Erro 40008 - Invalid operation for forward-only cursor ( error, only
version driver psqlODBC 7.2.1)

thank's.


Robson Martins
from Brazil

 << File: ATT00026.htm >>