Thread: Attempting pull postgres data into excel

Attempting pull postgres data into excel

From
"Tore Lukashaugen"
Date:
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

Re: Attempting pull postgres data into excel

From
Tom Lane
Date:
"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