Re: Word 2002 - cannot list tables

I am trying to merge letters using MS Word 2002.  I have set up a DSN
using the current version of the PostgreSQL ODBC driver.  I don't think
I'm using MS Query.  I'm not very familiar with Word (I don't personally
use it), I'm trying to set up merge documents for someone who must use
Word.  Should be simple.

I try to select the datasource using the 'Open Data Source' button on
the toolbar.  I then select New Source -> ODBC DSN -> 'My PostgreSQL
DSN' and I get this error:

Unable to obtain a list of tables from the data source.

Randall

Greg Campbell wrote:

> I don't want to come off as harsh, but seriously, you are looking for
> help and extent of your problem description is you are trying to
> connect MS Word to a PostgreSQL database via ODBC and it says you
> can't get a list of tables.
>
> MS Word is a word processor,.. PostgreSQL is a database, these thing
> we know. So help us help you. Is MS Query involved? Are the scripting
> capacities of Word VBA involved? Did you set up a datasource name
> (DSN)? what steps have you taken? When does the error occur?
>
> Randall Smith wrote:
>
>> I'm trying to use the pgsql-odbc driver to connect MS Word 2002 to
>> PostgreSQL.  Word gives me an error saying that it can't get a list
>> of tables.  I've tried setting the search_path to pg_schema and the
>> schema I'm interested in, but I keep getting the same error.  Anyone
>> here had any luck with MS Word 2002?
>>
>> Randall
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>