Thread: XP Excel with PostgreSQL on Linux?

XP Excel with PostgreSQL on Linux?

From
Kelsey Forsythe
Date:
I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
database on a Linux box.
I've setup the DBN (ODBC) in AdminSettings--> Data Sources

And I can go into Excel at go through all the Data Source setup
and test the connection (it is fine) BUT I receive 'Unable to obtain
list of tables from data source'
What other information besides the username and password do I need?

Do I need to configure the server in some way to allow upload of this
information?
Maybe the server firewall is setup to not allow this?
Maybe I need to setup a UDL?

Although I can get to that same port using a Tomcat application.

Any help is appreciated.

Thanks,

Kelsey

Re: XP Excel with PostgreSQL on Linux?

From
George Weaver
Date:
> Kelsey Forsythe wrote:

>I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
> database on a Linux box.
> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>
> And I can go into Excel at go through all the Data Source setup
> and test the connection (it is fine) BUT I receive 'Unable to obtain
> list of tables from data source'
> What other information besides the username and password do I need?
>
> Do I need to configure the server in some way to allow upload of this
> information?
> Maybe the server firewall is setup to not allow this?
> Maybe I need to setup a UDL?
>
> Although I can get to that same port using a Tomcat application.
>
> Any help is appreciated.

This might help:

http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php

Regards,
George

Re: XP Excel with PostgreSQL on Linux?

From
"Karl Denninger"
Date:
I doubt it - we have the same problem with no clean resolution (thus far)

-- Karl Denninger  karl@denninger.net
Diving?  See http://www.scubaforum.org

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of George Weaver
Sent: Tuesday, March 06, 2007 5:09 PM
To: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?


> Kelsey Forsythe wrote:

>I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
> database on a Linux box.
> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>
> And I can go into Excel at go through all the Data Source setup
> and test the connection (it is fine) BUT I receive 'Unable to obtain
> list of tables from data source'
> What other information besides the username and password do I need?
>
> Do I need to configure the server in some way to allow upload of this
> information?
> Maybe the server firewall is setup to not allow this?
> Maybe I need to setup a UDL?
>
> Although I can get to that same port using a Tomcat application.
>
> Any help is appreciated.

This might help:

http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php

Regards,
George

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

               http://archives.postgresql.org


%SPAMBLOCK-SYS: Matched [hub.org+], message ok

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007
9:41 AM

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007
9:41 AM




%SPAMBLOCK-SYS: Matched [@postgresql.org+], message ok

Re: XP Excel with PostgreSQL on Linux?

From
David Gardner
Date:
Hmm, I don't have much experiance with Excel, but I have found the Query
wizard to not work too well. I found that if I went to: Data->Import
External Data->New Database Query  then make sure the "Use the Query
Wizard" box is unchecked, select my DSN, then clock the "SQL" button and
then type in a SQL statement, it would input the data correctly into
Excel. Note, you may have to put quotation marks around the table/column
names.

Kelsey Forsythe wrote:
> I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
> database on a Linux box.
> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>
> And I can go into Excel at go through all the Data Source setup
> and test the connection (it is fine) BUT I receive 'Unable to obtain
> list of tables from data source'
> What other information besides the username and password do I need?
>
> Do I need to configure the server in some way to allow upload of this
> information?
> Maybe the server firewall is setup to not allow this?
> Maybe I need to setup a UDL?
>
> Although I can get to that same port using a Tomcat application.
>
> Any help is appreciated.
>
> Thanks,
>
> Kelsey
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


Re: XP Excel with PostgreSQL on Linux?

From
"Joshua D. Drake"
Date:
Karl Denninger wrote:
> I doubt it - we have the same problem with no clean resolution (thus far)
>

Have you tried with ODBCng?

Joshua D. Drake

> -- Karl Denninger  karl@denninger.net
> Diving?  See http://www.scubaforum.org
>
> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of George Weaver
> Sent: Tuesday, March 06, 2007 5:09 PM
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?
>
>
>
>> Kelsey Forsythe wrote:
>>
>
>
>> I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
>> database on a Linux box.
>> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>>
>> And I can go into Excel at go through all the Data Source setup
>> and test the connection (it is fine) BUT I receive 'Unable to obtain
>> list of tables from data source'
>> What other information besides the username and password do I need?
>>
>> Do I need to configure the server in some way to allow upload of this
>> information?
>> Maybe the server firewall is setup to not allow this?
>> Maybe I need to setup a UDL?
>>
>> Although I can get to that same port using a Tomcat application.
>>
>> Any help is appreciated.
>>
>
> This might help:
>
> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php
>
> Regards,
> George
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>
> %SPAMBLOCK-SYS: Matched [hub.org+], message ok
>
>


Re: XP Excel with PostgreSQL on Linux?

From
"Karl Denninger"
Date:
No - where do I find that?

-- Karl Denninger  karl@denninger.net
Diving?  See http://www.scubaforum.org

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Tuesday, March 06, 2007 7:07 PM
To: Karl Denninger
Cc: 'George Weaver'; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?

Karl Denninger wrote:
> I doubt it - we have the same problem with no clean resolution (thus far)
>

Have you tried with ODBCng?

Joshua D. Drake

> -- Karl Denninger  karl@denninger.net
> Diving?  See http://www.scubaforum.org
>
> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of George Weaver
> Sent: Tuesday, March 06, 2007 5:09 PM
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?
>
>
>
>> Kelsey Forsythe wrote:
>>
>
>
>> I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
>> database on a Linux box.
>> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>>
>> And I can go into Excel at go through all the Data Source setup
>> and test the connection (it is fine) BUT I receive 'Unable to obtain
>> list of tables from data source'
>> What other information besides the username and password do I need?
>>
>> Do I need to configure the server in some way to allow upload of this
>> information?
>> Maybe the server firewall is setup to not allow this?
>> Maybe I need to setup a UDL?
>>
>> Although I can get to that same port using a Tomcat application.
>>
>> Any help is appreciated.
>>
>
> This might help:
>
> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php
>
> Regards,
> George
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>
> %SPAMBLOCK-SYS: Matched [hub.org+], message ok
>
>



%SPAMBLOCK-SYS: Matched [+pgsql-odbc-owner@postgresql.org], message ok

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007
9:41 AM


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007
9:41 AM




%SPAMBLOCK-SYS: Matched [@postgresql.org+], message ok

Re: XP Excel with PostgreSQL on Linux?

From
"Joshua D. Drake"
Date:
Karl Denninger wrote:
> No - where do I find that?
>
http://projects.commandprompt.com/public/odbcng


> -- Karl Denninger  karl@denninger.net
> Diving?  See http://www.scubaforum.org
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Tuesday, March 06, 2007 7:07 PM
> To: Karl Denninger
> Cc: 'George Weaver'; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?
>
> Karl Denninger wrote:
>
>> I doubt it - we have the same problem with no clean resolution (thus far)
>>
>>
>
> Have you tried with ODBCng?
>
> Joshua D. Drake
>
>
>> -- Karl Denninger  karl@denninger.net
>> Diving?  See http://www.scubaforum.org
>>
>> -----Original Message-----
>> From: pgsql-odbc-owner@postgresql.org
>> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of George Weaver
>> Sent: Tuesday, March 06, 2007 5:09 PM
>> To: pgsql-odbc@postgresql.org
>> Subject: Re: [ODBC] XP Excel with PostgreSQL on Linux?
>>
>>
>>
>>
>>> Kelsey Forsythe wrote:
>>>
>>>
>>
>>
>>> I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
>>> database on a Linux box.
>>> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>>>
>>> And I can go into Excel at go through all the Data Source setup
>>> and test the connection (it is fine) BUT I receive 'Unable to obtain
>>> list of tables from data source'
>>> What other information besides the username and password do I need?
>>>
>>> Do I need to configure the server in some way to allow upload of this
>>> information?
>>> Maybe the server firewall is setup to not allow this?
>>> Maybe I need to setup a UDL?
>>>
>>> Although I can get to that same port using a Tomcat application.
>>>
>>> Any help is appreciated.
>>>
>>>
>> This might help:
>>
>> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00013.php
>>
>> Regards,
>> George
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>>
>>
>> %SPAMBLOCK-SYS: Matched [hub.org+], message ok
>>
>>
>>
>
>
>
> %SPAMBLOCK-SYS: Matched [+pgsql-odbc-owner@postgresql.org], message ok
>
>