Re: Word 2002 - cannot list tables

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@tnr.cc>
> To: "Greg Campbell" <greg.campbell@us.michelin.com>
> Cc: <pgsql-odbc@postgresql.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