pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Question
6+ messages / 4 participants
[nested] [flat]
* ODBC Question
@ 1999-09-17 02:01 Len Morgan <len-morgan@crcom.net>
0 siblings, 0 replies; 6+ messages in thread
From: Len Morgan @ 1999-09-17 02:01 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
I just downloaded the latest postodbc driver (v0007). When I install it and
try and set it up, it only gives me the options for Postgres versions 6.2,
6.3, and 6.4. Will this still work for 6.5.1? Does 6.4 really mean 6.4+?
Thanks.
len morgan
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] ODBC Question
@ 1999-09-17 02:38 Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 6+ messages in thread
From: Ken J. Wright @ 1999-09-17 02:38 UTC (permalink / raw)
To: Len Morgan <len-morgan@crcom.net>; pgsql-interfaces@hub.org
At 21:01 09/16/1999 -0500, Len Morgan wrote:
>I just downloaded the latest postodbc driver (v0007). When I install it and
>try and set it up, it only gives me the options for Postgres versions 6.2,
>6.3, and 6.4. Will this still work for 6.5.1? Does 6.4 really mean 6.4+?
6.4 is for 6.4x and above (6.4.0, 6.4.1, 6.5.0, 6.5.1).
Ken
^ permalink raw reply [nested|flat] 6+ messages in thread
* ODBC question
@ 2000-06-28 12:40 Carolyn Lu Wong <carolyn@greatpacific.com.au>
0 siblings, 1 reply; 6+ messages in thread
From: Carolyn Lu Wong @ 2000-06-28 12:40 UTC (permalink / raw)
To: pgsql-interfaces
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?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC question
@ 2000-06-28 13:38 Kardos, Dr. Andreas <kardos@repas-aeg.de>
parent: Carolyn Lu Wong <carolyn@greatpacific.com.au>
0 siblings, 1 reply; 6+ messages in thread
From: Kardos, Dr. Andreas @ 2000-06-28 13:38 UTC (permalink / raw)
To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: pgsql-interfaces
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?
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC question
@ 2000-06-29 02:00 Carolyn Lu Wong <carolyn@greatpacific.com.au>
parent: Kardos, Dr. Andreas <kardos@repas-aeg.de>
0 siblings, 1 reply; 6+ messages in thread
From: Carolyn Lu Wong @ 2000-06-29 02:00 UTC (permalink / raw)
To: Kardos, Dr. Andreas <kardos@repas-aeg.de>; pgsql-interfaces
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?
> >
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC question
@ 2000-06-29 09:11 Kardos, Dr. Andreas <kardos@repas-aeg.de>
parent: Carolyn Lu Wong <carolyn@greatpacific.com.au>
0 siblings, 0 replies; 6+ messages in thread
From: Kardos, Dr. Andreas @ 2000-06-29 09:11 UTC (permalink / raw)
To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: 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@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?
> >
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-06-29 09:11 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-17 02:01 ODBC Question Len Morgan <len-morgan@crcom.net>
1999-09-17 02:38 Re: [INTERFACES] ODBC Question Ken J. Wright <ken@ori-ind.com>
2000-06-28 12:40 ODBC question Carolyn Lu Wong <carolyn@greatpacific.com.au>
2000-06-28 13:38 ` Re: ODBC question Kardos, Dr. Andreas <kardos@repas-aeg.de>
2000-06-29 02:00 ` Re: ODBC question Carolyn Lu Wong <carolyn@greatpacific.com.au>
2000-06-29 09:11 ` Re: ODBC question Kardos, Dr. Andreas <kardos@repas-aeg.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox