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

Re: Word 2002 - cannot list tables

From: Randall Smith <randall(at)tnr(dot)cc>
To: Greg Campbell <greg(dot)campbell(at)us(dot)michelin(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Word 2002 - cannot list tables
Date: 2004-12-22 20:10:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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.


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?

In response to


pgsql-odbc by date

Next:From: Robert TreatDate: 2004-12-22 20:38:40
Subject: Re: Word 2002 - cannot list tables
Previous:From: terryDate: 2004-12-22 19:49:36
Subject: Re: Word 2002 - cannot list tables

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