Re: Trouble Importing Data to Excel "unable to obtain a list of tables"

--- Carter Patterson <carter@fortedata.com> wrote:
> I am trying to connect Excel and Postgres.
>
> I have Postgres 7.3.2 installed on RH 8.0 box.
> I have loaded pgsqlodbc 7.3.1 installed on my
> Windows XP Professional.
> MS Excel 2002
>
> I went to Control Panel, Admin Tools, DataSources
> and added a DSN for
> Postgres.  I checked the 7.X, 6.4 box.
> I also told it to show system tables.
>
>
> In Excel, I choose Data, Import External Data,
> Import Data, Connect to
> New Data Source---
>
> This takes me to the Excel Wizard where I choose
> ODBC - DSN, then I
> select Postgresql30.  It then tells me unable to
> obtain a list of
> tables.

Sounds like you have done everything right, so I would
suspect a connection problem.  Is your Postgres
accepting tcp/ip connections (needs postmaster started
with "-i" switch, or "tcpip = true" in
postgresql.conf)?  Do you have logging enabled for
ODBC or for Postgres?  If so, what do the logs show?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com