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.
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 :
> ; Everything after this line is an OLE DB initstring
> Provider=MSDASQL.1;Persist Security Info=False;Data Source=test72
> ----- 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
In response to
pgsql-odbc by date
|Next:||From: Hernán Quezada||Date: 2004-12-28 14:31:42|
|Subject: send odbc|
|Previous:||From: George Weaver||Date: 2004-12-23 16:45:43|
|Subject: Problems with Beta 5 and odbc driver 8.00.00.02|