Re: Word 2002 - cannot list tables

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

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

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Greg Campbell
> Sent: Wednesday, December 22, 2004 2:31 PM
> To: Randall Smith
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Word 2002 - cannot list tables
>
>
> 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?

I may come off sounding harsh (but I don't care): If you use the right tool for the job, you might
find your job easier.

If you want to map schema, use a schema mapping tool. There are lots of them out there. Case
Studio is an example of one that works with Postgres (casestudio.com). And no, I don't work for
casestudio. I don't even use it (it only runs on windows, which I try to avoid crashing, er,
using).

BTW
I don't use Word to map schema.
I don't use Outlook to draw images.
And I don't scrub my floors with a toothbrush.

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

>
> 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
>
>

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
>
>

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

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)
>>
>>
>
>
>

Access is not on the machine. However, merges currently work in Open
Office.

Randall

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)
>>
>>
>
>
>

Hi Randall,

I'm not going to be harsh.

You might want to try setting up a "universal data link" (.udl) file in My
Documents, under My Data Sources. I have used such a link on occasion. I
just tried it with Word 2002 and was able to successfully link to
PostgreSQL.

In My Data Sources create a .txt file and then change the extension to
".udl". Then double click on the file to open it. It will bring up a
datalink properties wizard that will let you set the provider, etc. Try the
Microsoft OLE DB Provider for ODBC Drivers under Provider. Under the
Connection tab, specify the DSN you set up - it should be in the drop down
box beside "Use data source name". You shouldn't have to set any other
parameters since they should already be set in the DSN you set up. Try the
Test Connection button to see if you can connect.

In Word 2002, choose Insert Database from the toolbar - then Get Data. When
it asks you to select your data source, click on the .udl file you just
created, then Open. It should retrieve the tables in the database for you.

There's not much in the .udl file. This is what was in the file I just
created to test linking to Word :

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Data Source=test72

HTH,

Regards,
George

----- Original Message -----
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>
Sent: Wednesday, December 22, 2004 2:10 PM
Subject: Re: [ODBC] Word 2002 - cannot list tables

>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

Thank you George. I'll give it a try and post my results to this list.
It may be a few days because I'm traveling.

Happy Holidays!

Randall

George Weaver wrote:
> Hi Randall,
>
> I'm not going to be harsh.
>
> You might want to try setting up a "universal data link" (.udl) file in
> My Documents, under My Data Sources. I have used such a link on
> occasion. I just tried it with Word 2002 and was able to successfully
> link to PostgreSQL.
>
> In My Data Sources create a .txt file and then change the extension to
> ".udl". Then double click on the file to open it. It will bring up a
> datalink properties wizard that will let you set the provider, etc. Try
> the Microsoft OLE DB Provider for ODBC Drivers under Provider. Under
> the Connection tab, specify the DSN you set up - it should be in the
> drop down box beside "Use data source name". You shouldn't have to set
> any other parameters since they should already be set in the DSN you set
> up. Try the Test Connection button to see if you can connect.
>
> In Word 2002, choose Insert Database from the toolbar - then Get Data.
> When it asks you to select your data source, click on the .udl file you
> just created, then Open. It should retrieve the tables in the database
> for you.
>
> There's not much in the .udl file. This is what was in the file I just
> created to test linking to Word :
>
> [oledb]
> ; Everything after this line is an OLE DB initstring
> Provider=MSDASQL.1;Persist Security Info=False;Data Source=test72
>
> HTH,
>
> Regards,
> George
>
>
> ----- Original Message ----- 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>
> Sent: Wednesday, December 22, 2004 2:10 PM
> Subject: Re: [ODBC] Word 2002 - cannot list tables
>
>
>> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org