Re: XP Excel with PostgreSQL on Linux?

> Kelsey Forsythe wrote:

>I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
> database on a Linux box.
> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>
> And I can go into Excel at go through all the Data Source setup
> and test the connection (it is fine) BUT I receive 'Unable to obtain
> list of tables from data source'
> What other information besides the username and password do I need?
>
> Do I need to configure the server in some way to allow upload of this
> information?
> Maybe the server firewall is setup to not allow this?
> Maybe I need to setup a UDL?
>
> Although I can get to that same port using a Tomcat application.
>
> Any help is appreciated.

This might help:

http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php

Regards,
George