--- On Fri, 11/23/07, Finn Lassen <dcio@AxiomInt.com> wrote:
> There is no "(" field. The "(" is the
> SQL syntax for enumerating the
> fields to be populated.
>> 2007-11-22 20:21:14 STATEMENT: BEGIN;insert into "public"."Contact1" ("", "Department", ..., "(", ... ) values
(E'93100765018597400Bru'...
Actually if you've noticed from this insert statement that you've previously posted, "(" is listed as a column name for
datato be inserted. This must be caused by either the ODBC or ADO driver is telling PostgreSQL to insert data into a
columnthat doesn't really exist. My gut feeling is that this shouldn't be a problem caused by the ODBC driver hence my
suggestto specifically call out the column names of your table when you assign values to your fields.
> P.S. Unfortunately I have already spent way more time on
> this than I can afford. This was supposed to be a quick
> evaluation to determine which database to replace the
> Borland with. I really should move on to looking at MySQL.
No arguments from me on this point. MySQL is a very good RDBMS also, and depending upon your needs it should work out
wellfor you. But if you later find that MySQL's features to not adequately satisfy some of you core development needs
youcould always give PostgreSQL a second try later on.
Regarding getting in touch with the developers, some of the ODBC developers subscribe to this mailing list. It could
bethat developers haven't had an opportunity to responded since this is a holiday weekend and may be unavailable.
However, the ODBC project has an official web-page for developers and bug reporting.
http://pgfoundry.org/projects/psqlodbc/
http://pgfoundry.org/tracker/?func=add&group_id=1000125&atid=538
Also, 3rd party vendor (Command Prompt) has developed their own ODBC driver that is supposed to have a more aggressive
datacaching mechanism. I haven't used it since the Official ODBC driver has worked so well in my case. You could see
ifthis driver produces different results.
https://projects.commandprompt.com/public/odbcng/wiki/Downloads
They also have a mailing list dedicated to this driver:
http://lists.commandprompt.com/mailman/listinfo/odbcng
Regards,
Richard Broersma Jr.