Postgres (NT), ODBC and DBTools
| От | Tim Teulings | 
|---|---|
| Тема | Postgres (NT), ODBC and DBTools | 
| Дата | |
| Msg-id | 3820116E.E9D26D78@materna.de обсуждение исходный текст | 
| Список | 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.
		
	В списке pgsql-interfaces по дате отправления: