Thread: XP Excel with PostgreSQL on Linux?
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
> 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
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
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 >
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 > >
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
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 > >