Thread: Trouble Importing Data to Excel "unable to obtain a list of tables"
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.
Any help or direction to documentation would be appreciated. thanks
--- 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
Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
From
"Carter Patterson"
Date:
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
Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
From
"Rommel the iCeMAn"
Date:
I also had a strikingly similar problem while trying to connect from Crystal Reports. It only worked when I changed all the PostgreSQL table names to lowercase. I read somewhere that uppercase names can be used if enclosed in quotes but that didn't work for me. just a suggestion :-) Rommel the iCeMAn Computer Programmer Barbados, Caribbean.
Carter, Just curious: was this the problem? Jeff --- Rommel the iCeMAn <iceman@sunbeach.net> wrote: > I also had a strikingly similar problem while trying > to connect from Crystal > Reports. It only worked when I changed all the > PostgreSQL table names to > lowercase. I read somewhere that uppercase names can > be used if enclosed in > quotes but that didn't work for me. > > just a suggestion :-) > Rommel the iCeMAn > Computer Programmer > Barbados, Caribbean. > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
From
"Carter Patterson"
Date:
No, I only use lower case names. I was able to import data into excel via another method. Instead of using the Excel selection "Import Data", I selected New Database Query, which essentially runs MS Query. This worked just fine. This would lead me to believe that there is a good possibility that the Import Data feature of Excel has its own bugs. Thanks for your help everyone. -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jeff Eckermann Sent: Wednesday, June 18, 2003 9:05 AM To: Rommel the iCeMAn; PostgreSQL ODBC List Cc: carter@fortedata.com Subject: Re: [ODBC] Trouble Importing Data to Excel "unable to obtain a list of tables" Carter, Just curious: was this the problem? Jeff --- Rommel the iCeMAn <iceman@sunbeach.net> wrote: > I also had a strikingly similar problem while trying > to connect from Crystal > Reports. It only worked when I changed all the > PostgreSQL table names to > lowercase. I read somewhere that uppercase names can > be used if enclosed in > quotes but that didn't work for me. > > just a suggestion :-) > Rommel the iCeMAn > Computer Programmer > Barbados, Caribbean. > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org __________________________________ 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