Thread: Attempting pull postgres data into excel
I am attempting to pull data into excel through odbc from postgres 8.2 running on vista.
I have set-up an ODBC DSN as follows:
Database: db_name
Server: localhost
Port: 5432
username: postgres
The test connection from the ODBC data source administration is succesful, but when I attempt to connect through Excel it gives me the following error: 'Unable to obtain list of tables from the data source'.
Any idea what is going on here?
Thanks
"Tore Lukashaugen" <tore@lukashaugen.freeserve.co.uk> writes:
> I am attempting to pull data into excel through odbc from postgres 8.2 running on vista.
> The test connection from the ODBC data source administration is succesful, but when I attempt to connect through
Excelit gives me the following error: 'Unable to obtain list of tables from the data source'.
Which ODBC driver are you using? It sounds like it's not compatible
with this version of Postgres, but it's hard to say more than that.
Looking into the postmaster log to see what the server thinks went wrong
might be instructive.
regards, tom lane