Lists: | pgsql-odbc |
---|
From: | "Tore Lukashaugen" <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Attempting pull postgres data into excel |
Date: | 2008-02-02 16:54:58 |
Message-ID: | AE25154910A346E4B017D6138CDF2A38@ToreServer |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Tore Lukashaugen" <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Attempting pull postgres data into excel |
Date: | 2008-02-02 17:45:24 |
Message-ID: | 7864.1201974324@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
"Tore Lukashaugen" <tore(at)lukashaugen(dot)freeserve(dot)co(dot)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 Excel it 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