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

Re: Word 2002 - cannot list tables

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Randall Smith <randall(at)tnr(dot)cc>
Cc: Greg Campbell <greg(dot)campbell(at)us(dot)michelin(dot)com>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Word 2002 - cannot list tables
Date: 2004-12-22 20:38:40
Message-ID: 200412221538.40640.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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)

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Responses

pgsql-odbc by date

Next:From: Randall SmithDate: 2004-12-22 21:00:16
Subject: Re: Word 2002 - cannot list tables
Previous:From: Randall SmithDate: 2004-12-22 20:10:11
Subject: Re: Word 2002 - cannot list tables

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