Обсуждение: ODBC question

hi

I'm writing client application with VB5 which connects to PostgreSQL via
PsqlODBC.

When I select a set of data with RecordSet from VB, I can't seem to
update the record set and has the following error message:

S1C00: Onlye SQL_POSITION/REFRESH is supported for SQLSetPos.

Any idea?

Set the CurserDriver Property of the Connection Object to rdUseOdbc.

Andreas Kardos

-----Ursprüngliche Nachricht-----
Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
An: <pgsql-interfaces@postgresql.org>
Gesendet: Mittwoch, 28. Juni 2000 14:40
Betreff: [INTERFACES] ODBC question


> hi
>
> I'm writing client application with VB5 which connects to PostgreSQL via
> PsqlODBC.
>
> When I select a set of data with RecordSet from VB, I can't seem to
> update the record set and has the following error message:
>
> S1C00: Onlye SQL_POSITION/REFRESH is supported for SQLSetPos.
>
> Any idea?
>

I'm using DAO, not RDO, create record sets as follows:

Set WS = DBEngine.CreateWorkspace("MainWS", "user", vbNullString,
dbUseODBC)
Set CN = WS.OpenConnection("", dbDriverNoPrompt, False, strConnect)
Set RS = CN.OpenRecordset(strSQL, dbOpenDynaset, dbExecDirect,
dbOptimistic)

where WS, CN and RS are defined as workspace, connection and recordset.


"Kardos, Dr. Andreas" wrote:
> 
> Set the CurserDriver Property of the Connection Object to rdUseOdbc.
> 
> Andreas Kardos
> 
> -----Ursprüngliche Nachricht-----
> Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
> An: <pgsql-interfaces@postgresql.org>
> Gesendet: Mittwoch, 28. Juni 2000 14:40
> Betreff: [INTERFACES] ODBC question
> 
> > hi
> >
> > I'm writing client application with VB5 which connects to PostgreSQL via
> > PsqlODBC.
> >
> > When I select a set of data with RecordSet from VB, I can't seem to
> > update the record set and has the following error message:
> >
> > S1C00: Onlye SQL_POSITION/REFRESH is supported for SQLSetPos.
> >
> > Any idea?
> >

With DAO this is the same story, but in the Workspace object:

WS.DefaultCursorDriver = dbUseODBCCursor

-----Ursprüngliche Nachricht-----
Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
An: Kardos, Dr. Andreas <kardos@repas-aeg.de>;
<pgsql-interfaces@postgresql.org>
Gesendet: Donnerstag, 29. Juni 2000 04:00
Betreff: Re: [INTERFACES] ODBC question


I'm using DAO, not RDO, create record sets as follows:

Set WS = DBEngine.CreateWorkspace("MainWS", "user", vbNullString,
dbUseODBC)
Set CN = WS.OpenConnection("", dbDriverNoPrompt, False, strConnect)
Set RS = CN.OpenRecordset(strSQL, dbOpenDynaset, dbExecDirect,
dbOptimistic)

where WS, CN and RS are defined as workspace, connection and recordset.


"Kardos, Dr. Andreas" wrote:
>
> Set the CurserDriver Property of the Connection Object to rdUseOdbc.
>
> Andreas Kardos
>
> -----Ursprüngliche Nachricht-----
> Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
> An: <pgsql-interfaces@postgresql.org>
> Gesendet: Mittwoch, 28. Juni 2000 14:40
> Betreff: [INTERFACES] ODBC question
>
> > hi
> >
> > I'm writing client application with VB5 which connects to PostgreSQL via
> > PsqlODBC.
> >
> > When I select a set of data with RecordSet from VB, I can't seem to
> > update the record set and has the following error message:
> >
> > S1C00: Onlye SQL_POSITION/REFRESH is supported for SQLSetPos.
> >
> > Any idea?
> >