Postgres (NT), ODBC and DBTools

From: Tim Teulings <Tim(dot)Teulings(at)materna(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postgres (NT), ODBC and DBTools
Date: 1999-11-03 10:41:50
Message-ID: 3820116E.E9D26D78@materna.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 1999-11-03 13:47:26 Re: [INTERFACES] Postgres (NT), ODBC and DBTools
Previous Message Peter Mount 1999-11-03 07:27:50 RE: [INTERFACES] Inifinite socket send from backend to java servl et