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

Re: Word 2002 - cannot list tables

From: Randall Smith <randall(at)tnr(dot)cc>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Word 2002 - cannot list tables
Date: 2004-12-22 21:00:16
Message-ID: 41C9E060.6030002@tnr.cc (view raw or flat)
Thread:
Lists: pgsql-odbc

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(at)postgresql(dot)org)
>>    
>>
>
>  
>

In response to

pgsql-odbc by date

Next:From: Randall SmithDate: 2004-12-22 21:15:40
Subject: Re: Word 2002 - cannot list tables
Previous:From: Robert TreatDate: 2004-12-22 20:38:40
Subject: Re: Word 2002 - cannot list tables

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