Skip site navigation (1) Skip section navigation (2)

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

From: Edzard Pasma <edzard(at)volcanomail(dot)com>
To: edzard(at)volcanomail(dot)com, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Unable to obtain list of tables from the data source
Date: 2005-06-02 16:35:05
Message-ID: 20050602163505.A885138142@sitemail.everyone.net (view raw or flat)
Thread:
Lists: pgsql-odbc
<html><body><P><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>Hello,</FONT></P>
<P><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>No luck with Word 2003 either, nor with mysql or sqlite odbc drivers. Suspect Bill Gates plays some dirty trick and I&nbsp;don't want to promote MS Office to much here. But I found a 99% solution for postgresql to at least overtrump sqlserver.</FONT></P>
<P><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>Intended to use the Office 2000 version on a seperate PC, just for mail merge. But when I opened an existing Main Document from Word XP by chance, no error occured at all and it could be happily used. Text and Merge fields can be added to the layout and query criteria can be changed. So I only need Word 2000 to create an empty Main document with the datasource attached and save this as a template Main document for Word XP. Not sure if XP also lets you change the table here. I use only one view and pre-select that in the template with all its columns and a dummy criterium to reduce the initial amount of data.</FONT></P>
<P><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>Did not see any happy users yet (there is an overwhelming amount of icons and options in Word XP) but the data is in their hands now.</FONT></P>
<P><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>Bye, Edzard Pasma<BR><BR>&nbsp;<BR>--- Edzard Pasma &lt;edzard(at)volcanomail(dot)com&gt; wrote:<BR>&nbsp;<BR><B>From:</B> Edzard Pasma &lt;edzard(at)volcanomail(dot)com&gt;<BR><B>Date:</B> Sun, 15 May 2005 05:10:31 -0700 (PDT)<BR><B>To:</B> pgsql-odbc(at)postgresql(dot)org<BR><B>Subject:</B> Unable to obtain list of tables from the data source<BR><BR></P>
<P><FONT face="Arial, Helvetica, sans-serif" size=2>Hello,</FONT></P>
<P><FONT face="Arial, Helvetica, sans-serif" size=2>I'm struggling with&nbsp;the "Unable to obtain list of tables from the data source" error.&nbsp;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 no luck. 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 more particular than older versions. Word 2000 plus the v7.3&nbsp;driver (7.03.02.00)&nbsp;work fine. Now I wonder how newer MS Office versions behave. Did anybody ever&nbsp;try Word 2004 or 2005? (if these exist at all). </FONT></P>
<P><FONT face="Arial, Helvetica, sans-serif" size=2>Happy with pg&nbsp;anyway, Edzard Pasma</FONT></P><BR>&nbsp;<BR>
<HR>
Tired of spam and viruses? Get a VolcanoMail account with SpamShield Pro and Anti-Virus technology! http://www.volcanomail.com/<BR></FONT><br>&nbsp;<br><hr>Tired of spam and viruses? Get a VolcanoMail account with SpamShield Pro and Anti-Virus technology! http://www.volcanomail.com/<br></body></html>


Attachment: unknown_filename
Description: text/html (3.0 KB)

pgsql-odbc by date

Next:From: TimDate: 2005-06-02 19:22:52
Subject: Specifying character sets in ODBC
Previous:From: Jonathan FuerthDate: 2005-06-02 16:32:44
Subject: Frontend/Backend protocol 3.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group