Thread: Unable to obtain list of tables from the data source

Unable to obtain list of tables from the data source

From
Edzard Pasma
Date:
<p><font face="Arial, Helvetica, sans-serif" size="2">Hello,</font><p><font face="Arial, Helvetica, sans-serif"
size="2">I'mstruggling with the "Unable to obtain list of tables from the data source" error. This occurs in MS Word
2002when performing mail merge and opening an ODBC datasource, configured with the Postgresql driver. I tried several
versionof the driver, 7.1., 7.2, 7.3 and 8.0.1 with no luck. There is no need to go in further detail as this was
vastlydiscussed just a couple of month ago. (<a href="http://archives.postgresql.org/pgsql-odbc/2004-12/msg00056.php"
target="_blank"><fontcolor="#000000">http://archives.postgresql.org/pgsql-odbc/2004-12/msg00056.php</font></a>). I find
thatWord 2002 is more particular than older versions. Word 2000 plus the v7.3 driver (7.03.02.00) work fine. Now I
wonderhow newer MS Office versions behave. Did anybody ever try Word 2004 or 2005? (if these exist at all).
</font><p><fontface="Arial, Helvetica, sans-serif" size="2">Happy with pg anyway, Edzard Pasma</font><br /> <br /><hr
/>Tiredof spam and viruses? Get a VolcanoMail account with SpamShield Pro and Anti-Virus technology!
http://www.volcanomail.com/<br/> 

Re: Unable to obtain list of tables from the data source

From
Edzard Pasma
Date:
<p><font size="2" style="FONT-FAMILY: arial,helvetica,sans-serif">Hello,</font><p><font size="2" style="FONT-FAMILY:
arial,helvetica,sans-serif">Noluck with Word 2003 either, nor with mysql or sqlite odbc drivers. Suspect Bill Gates
playssome dirty trick and I don't want to promote MS Office to much here. But I found a 99% solution for postgresql to
atleast overtrump sqlserver.</font><p><font size="2" style="FONT-FAMILY: arial,helvetica,sans-serif">Intended to use
theOffice 2000 version on a seperate PC, just for mail merge. But when I opened an existing Main Document from Word XP
bychance, no error occured at all and it could be happily used. Text and Merge fields can be added to the layout and
querycriteria can be changed. So I only need Word 2000 to create an empty Main document with the datasource attached
andsave this as a template Main document for Word XP. Not sure if XP also lets you change the table here. I use only
oneview and pre-select that in the template with all its columns and a dummy criterium to reduce the initial amount of
data.</font><p><fontsize="2" style="FONT-FAMILY: arial,helvetica,sans-serif">Did not see any happy users yet (there is
anoverwhelming amount of icons and options in Word XP) but the data is in their hands now.</font><p><font size="2"
style="FONT-FAMILY:arial,helvetica,sans-serif">Bye, Edzard Pasma<br /><br /> <br />--- Edzard Pasma
<edzard@volcanomail.com>wrote:<br /> <br /><b>From:</b> Edzard Pasma <edzard@volcanomail.com><br
/><b>Date:</b>Sun, 15 May 2005 05:10:31 -0700 (PDT)<br /><b>To:</b> pgsql-odbc@postgresql.org<br /><b>Subject:</b>
Unableto obtain list of tables from the data source<br /><br /></font><p><font face="Arial, Helvetica, sans-serif"
size="2">Hello,</font><p><fontface="Arial, Helvetica, sans-serif" size="2">I'm struggling with the "Unable to obtain
listof tables from the data source" error. This occurs in MS Word 2002 when performing mail merge and opening an ODBC
datasource,configured with the Postgresql driver. I tried several version of the driver, 7.1., 7.2, 7.3 and 8.0.1 with
noluck. There is no need to go in further detail as this was vastly discussed just a couple of month ago. (<a
href="http://archives.postgresql.org/pgsql-odbc/2004-12/msg00056.php"target="_blank"><font
color="#000000">http://archives.postgresql.org/pgsql-odbc/2004-12/msg00056.php</font></a>).I find that Word 2002 is
moreparticular than older versions. Word 2000 plus the v7.3 driver (7.03.02.00) work fine. Now I wonder how newer MS
Officeversions behave. Did anybody ever try Word 2004 or 2005? (if these exist at all). </font><p><font face="Arial,
Helvetica,sans-serif" size="2">Happy with pg anyway, Edzard Pasma</font><br /> <br /><hr /> Tired of spam and viruses?
Geta VolcanoMail account with SpamShield Pro and Anti-Virus technology! http://www.volcanomail.com/<br /><br /> <br
/><hr/>Tired of spam and viruses? Get a VolcanoMail account with SpamShield Pro and Anti-Virus technology!
http://www.volcanomail.com/<br/>