Skip site navigation (1) Skip section navigation (2)

Re: Attempting pull postgres data into excel

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 (view raw or flat)
Thread:
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

In response to

pgsql-odbc by date

Next:From: Peter EisentrautDate: 2008-02-04 11:46:31
Subject: Communication error during authentication
Previous:From: Tore LukashaugenDate: 2008-02-02 16:54:58
Subject: Attempting pull postgres data into excel

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group