Re: [INTERFACES] Postgres (NT), ODBC and DBTools

> -----Original Message-----
> From: Tim Teulings [mailto:Tim(dot)Teulings(at)materna(dot)de]
> Sent: 03 November 1999 10:42
> To: pgsql-interfaces(at)postgreSQL(dot)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!