Message-ID: <3820116E.E9D26D78@materna.de>
Date: Wed, 03 Nov 1999 11:41:50 +0100
From: Tim Teulings <Tim.Teulings@materna.de>
Organization: Dr. Materna GmbH, Dortmund, Germany
To: pgsql-interfaces@postgresql.org
Subject: Postgres (NT), ODBC and DBTools
MIME-version: 1.0
Content-type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

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.