Re: New to ODBC with postgresql

Tim LoGrasso wrote:

> Some additional debug actions by me:
>
> I checked the mirror and realized I may not have the latest version of
> the ODBC driver. So, I downloaded from the msi directory the following
> file: psqlodbc-07_03_0100.zip
>
> I then uninstalled the existing driver and installed the 07_03_0100.zip
> driver.
>
> I now get the following error in MS Word: “Unable to obtain list of
> tables from the datasource.”
>
> I tried to connect via MS Access using the same DSN and I get the
> following error:
>
> “ODBC—call failed.
>
> ERROR: current transaction is aborted, queries
> ignored until end of transaction block (#7)”

It may help in debugging the situation if you turned statement logging
on in postgresql.conf by setting:

log_statement = true

On RedHat, the initialization script would then need to be edited so
output is not directed to /dev/null but a file instead. That way you
could examine the SQL statements the ODBC driver is sending to the
database.

Mike Mascari
mascarm(at)mascari(dot)com