Re: Trouble Importing Data to Excel "unable to obtain a list of tables" - Mailing list pgsql-odbc

From Carter Patterson
Subject Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
Date
Msg-id 003701c334db$c2871260$f90000c0@carter
Whole thread Raw
In response to Re: Trouble Importing Data to Excel "unable to obtain a list of tables"  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
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@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jeff Eckermann
Sent: Tuesday, June 17, 2003 9:04 AM
To: Carter Patterson; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] 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

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

               http://archives.postgresql.org


pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
Next
From: "Rommel the iCeMAn"
Date:
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"