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

Jeff:

I do have the '-i' option on through postgresql.conf flag. I can
connect to pgadmin without a problem.

In excel, it has a "Test Connection" button. It works fine. But when I
try to get a list of tables, I get the error message

Login failed: Catalog information cannot be retrieved.

I know the login and password are good. Here is the log. Thanks for
your help.

Carter

conn=35469000, PGAPI_DriverConnect(
in)='DSN=PostgreSQL30;UID=carter;PWD=xxxxxxxx;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL30',server='63.64.82.12',port='5432',dbase='forte',user='
carter',passwd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0
'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
conn=35469000, PGAPI_DriverConnect(
in)='DSN=PostgreSQL30;UID=carter;PWD=xxxxxxxx;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL30',server='63.64.82.12',port='5432',dbase='forte',user='
carter',passwd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0
'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jeff Eckermann
Sent: Tuesday, June 17, 2003 9:04 AM
To: Carter Patterson; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Trouble Importing Data to Excel "unable to obtain a
list of tables"

--- Carter Patterson <carter(at)fortedata(dot)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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org