Re: Word 2002 - cannot list tables

Robert Treat wrote:

>Can you connect using your DSN via Access?  You should at least be able to
>confirm if this is a Word problem or an ODBC problem.
>
>Robert Treat
>
>On Wednesday 22 December 2004 15:10, Randall Smith wrote:
>
>
>>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
>>>>
>>>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>
>>
>
>
>