Re: Word 2002 - cannot list tables

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)

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