From: | "Kardos, Dr(dot) Andreas" <kardos(at)repas-aeg(dot)de> |
---|---|
To: | "Carolyn Lu Wong" <carolyn(at)greatpacific(dot)com(dot)au> |
Cc: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: ODBC question |
Date: | 2000-06-29 09:11:11 |
Message-ID: | 01af01bfe1a9$f8ec94c0$99301eac@Dr.repas.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
With DAO this is the same story, but in the Workspace object:
WS.DefaultCursorDriver = dbUseODBCCursor
-----Ursprüngliche Nachricht-----
Von: Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au>
An: Kardos, Dr. Andreas <kardos(at)repas-aeg(dot)de>;
<pgsql-interfaces(at)postgresql(dot)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(at)greatpacific(dot)com(dot)au>
> An: <pgsql-interfaces(at)postgresql(dot)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?
> >
From | Date | Subject | |
---|---|---|---|
Next Message | grzegorz.przezdziecki | 2000-06-29 11:48:25 | PHP4 Postgresql *.dll |
Previous Message | Peter Mount | 2000-06-29 08:05:33 | RE: still confuse; no suitable driver |