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