If my memory serves me, this is a Delphi problem, and it depends on the connection tool you are using in Delphi to make the ODBC connection. It's been a while since I've worked with Delphi, but I remember having the same issue with earlier versions of PGSql with this same ODBC driver.
Gary Doades wrote:
On 27 Sep 2004 at 9:18, Melanie Bergeron wrote:
Thanks for your reply Gary. I have ODBC driver psqlodbc-07_03_0200. I
take a look at the mylog file and everything seems to work fine for the
query:
Any idea on what my problem could be??
Thanks,
Melanie
Well on first glance it doesn't look like a postgres problem or ODBC driver problem. It
would still perhaps be useful to look at an ODBC trace log (from the ODBC driver
manager).
Looking at the Delphi documentation I have I see that EDatabaseError can cover many
sins. Is there no other message that goes with it?
What are the datatypes of the string columns you are trying to retrieve?
Cheers,
Gary.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
.