pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres (NT), ODBC and DBTools
5+ messages / 4 participants
[nested] [flat]
* Postgres (NT), ODBC and DBTools
@ 1999-11-03 10:41 Tim Teulings <Tim.Teulings@materna.de>
0 siblings, 0 replies; 5+ messages in thread
From: Tim Teulings @ 1999-11-03 10:41 UTC (permalink / raw)
To: pgsql-interfaces
Hallo!
I have compiled the current postgres version under NT using cygwin
B20.1 and I have also installed the current ODBC driver.
Everything work fine (there seems to be some problems with multi
user access and I get some messages in the log file about semaphores,
but that is not yet a problem).
We also use DBTools from RogueWave to access postgres via the ODBC
driver. That works for select statements, but not for insert and
update statements, where I get syntax errors for statements that
obviously are correct and which do work unsing pgsql.
Since I had similar problems (on Linux) which older version, I estimate
that postgres exspects insert and update statements to finish with a
colon (";"). Is this correct?
If so, how can I solve my problem? (Ok, ";" is a statement divider and
thus should not be necessary...). I cannot modify the SQL generation
of DBTools since it encapsulates this. Can I make the ODBC driver
to simply add a colon? Are the sources available for this purpose?
Any help is welcome!
--
Gruß...
Tim.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Postgres (NT), ODBC and DBTools
@ 1999-11-03 13:47 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 1999-11-03 13:47 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Tim Teulings [mailto:Tim.Teulings@materna.de]
> Sent: 03 November 1999 10:42
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] Postgres (NT), ODBC and DBTools
> Since I had similar problems (on Linux) which older version,
> I estimate
> that postgres exspects insert and update statements to finish with a
> colon (";"). Is this correct?
Queries sent via the ODBC driver should not require the ';' - in fact, the
semi colon can cause problems, especially with MS ADO.
Have you tried switching on logging in the ODBC driver to see what is being
sent to the backend?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] Postgres (NT), ODBC and DBTools
@ 1999-11-03 15:21 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 1999-11-03 15:21 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: 'Tim.Teulings@materna.de' <Tim.Teulings@materna.de>
> -----Original Message-----
> From: Teulings, Tim [mailto:Tim.Teulings@materna.de]
> Sent: 03 November 1999 14:34
> To: 'pgsql-interfaces@postgresql.org'
> Subject: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
<Snip>
>
> After looking at it again, I'm not sure if it is a problem with the
> colon. The "?" in the statement looks supicious (itis near the
> 'where'
> stated in the error message). AFAIK ODBC does allow binding of
> variables
> (bind variable, bound expresion) and DBTools uses this. Is the "?"
> legal
> at this point (it references the value bound to a variable) or is it
> a
> error?
>
> Perhaps it is a problem with the ODBC driver settings?
I am sure that the ? is the problem. I've never heard of binding variables
with ODBC, but then I'm not an ODBC expert - I tend to let ADO/DAO deal with
that side of things!
Perhaps Byron or someone else can provide a definate answer?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] Postgres (NT), ODBC and DBTools
@ 1999-11-03 19:26 Ansley, Michael <Michael.Ansley@intec.co.za>
1999-11-03 19:54 ` RE: [INTERFACES] Postgres (NT), ODBC and DBTools Ken J. Wright <ken@ori-ind.com>
0 siblings, 1 reply; 5+ messages in thread
From: Ansley, Michael @ 1999-11-03 19:26 UTC (permalink / raw)
To: 'Dave Page ' <dpage@vale-housing.co.uk>; pgsql-interfaces; +Cc: ''Tim.Teulings@materna.de' ' <Tim.Teulings@materna.de>
Hi, Dave,
You actually can bind variables, but I've only ever seen it done with stored
procs. You may also be able to do it if you prepare the statement.
However, for a straight throw-away query, it seems a little odd.
How does PG handle this anyway?
MikeA
-----Original Message-----
From: Dave Page
To: 'pgsql-interfaces@postgresql.org'
Cc: 'Tim.Teulings@materna.de'
Sent: 99/11/03 05:21
Subject: RE: [INTERFACES] Postgres (NT), ODBC and DBTools
> -----Original Message-----
> From: Teulings, Tim [mailto:Tim.Teulings@materna.de]
> Sent: 03 November 1999 14:34
> To: 'pgsql-interfaces@postgresql.org'
> Subject: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
<Snip>
>
> After looking at it again, I'm not sure if it is a problem with the
> colon. The "?" in the statement looks supicious (itis near the
> 'where'
> stated in the error message). AFAIK ODBC does allow binding of
> variables
> (bind variable, bound expresion) and DBTools uses this. Is the "?"
> legal
> at this point (it references the value bound to a variable) or is it
> a
> error?
>
> Perhaps it is a problem with the ODBC driver settings?
I am sure that the ? is the problem. I've never heard of binding
variables
with ODBC, but then I'm not an ODBC expert - I tend to let ADO/DAO deal
with
that side of things!
Perhaps Byron or someone else can provide a definate answer?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
************
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] Postgres (NT), ODBC and DBTools
1999-11-03 19:26 RE: [INTERFACES] Postgres (NT), ODBC and DBTools Ansley, Michael <Michael.Ansley@intec.co.za>
@ 1999-11-03 19:54 ` Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ken J. Wright @ 1999-11-03 19:54 UTC (permalink / raw)
To: Ansley, Michael <Michael.Ansley@intec.co.za>; 'Dave Page ' <dpage@vale-housing.co.uk>; pgsql-interfaces; +Cc: ''Tim.Teulings@materna.de' ' <Tim.Teulings@materna.de>
>You actually can bind variables, but I've only ever seen it done with stored
>procs. You may also be able to do it if you prepare the statement.
>However, for a straight throw-away query, it seems a little odd.
>
>How does PG handle this anyway?
Postgres doesn't do any preparing or binding. That is all handled by the
ODBC driver. It would be nice if some day the backend would do this, but
'till then.....
Ken
>
>MikeA
>
>-----Original Message-----
>From: Dave Page
>To: 'pgsql-interfaces@postgresql.org'
>Cc: 'Tim.Teulings@materna.de'
>Sent: 99/11/03 05:21
>Subject: RE: [INTERFACES] Postgres (NT), ODBC and DBTools
>
>> -----Original Message-----
>> From: Teulings, Tim [mailto:Tim.Teulings@materna.de]
>> Sent: 03 November 1999 14:34
>> To: 'pgsql-interfaces@postgresql.org'
>> Subject: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
>
><Snip>
>>
>> After looking at it again, I'm not sure if it is a problem with the
>> colon. The "?" in the statement looks supicious (itis near the
>> 'where'
>> stated in the error message). AFAIK ODBC does allow binding of
>> variables
>> (bind variable, bound expresion) and DBTools uses this. Is the "?"
>> legal
>> at this point (it references the value bound to a variable) or is it
>> a
>> error?
>>
>> Perhaps it is a problem with the ODBC driver settings?
>
>I am sure that the ? is the problem. I've never heard of binding
>variables
>with ODBC, but then I'm not an ODBC expert - I tend to let ADO/DAO deal
>with
>that side of things!
>
>Perhaps Byron or someone else can provide a definate answer?
>
>Regards,
>
>Dave.
>
>--
>Network & Systems Manager, The Vale Housing Association.
>http://www.vale-housing.co.uk (Work)
>http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
>Beer can be a permanent solution, but only if you have enough of it!
>
>************
>
>************
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-11-03 19:54 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-03 10:41 Postgres (NT), ODBC and DBTools Tim Teulings <Tim.Teulings@materna.de>
1999-11-03 13:47 Re: [INTERFACES] Postgres (NT), ODBC and DBTools Dave Page <dpage@vale-housing.co.uk>
1999-11-03 15:21 RE: [INTERFACES] Postgres (NT), ODBC and DBTools Dave Page <dpage@vale-housing.co.uk>
1999-11-03 19:26 RE: [INTERFACES] Postgres (NT), ODBC and DBTools Ansley, Michael <Michael.Ansley@intec.co.za>
1999-11-03 19:54 ` Ken J. Wright <ken@ori-ind.com>
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