Attempting pull postgres data into excel

This is a multi-part message in MIME format.

------=_NextPart_000_004C_01C865BC.58046840
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am attempting to pull data into excel through odbc from postgres 8.2 =
running on vista.=20

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
------=_NextPart_000_004C_01C865BC.58046840
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: Attempting pull postgres data into excel

"Tore Lukashaugen" 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match