Re: 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(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

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

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(at)sunbeach(dot)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(at)postgresql(dot)org

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

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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jeff Eckermann
Sent: Wednesday, June 18, 2003 9:05 AM
To: Rommel the iCeMAn; PostgreSQL ODBC List
Cc: carter(at)fortedata(dot)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(at)sunbeach(dot)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(at)postgresql(dot)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