From: | Randall Smith <randall(at)tnr(dot)cc> |
---|---|
To: | George Weaver <gweaver(at)shaw(dot)ca> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Word 2002 - cannot list tables |
Date: | 2004-12-24 03:07:30 |
Message-ID: | 41CB87F2.2090102@tnr.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hernán Quezada | 2004-12-28 14:31:42 | send odbc |
Previous Message | George Weaver | 2004-12-23 16:45:43 | Problems with Beta 5 and odbc driver 8.00.00.02 |