Skip site navigation (1) Skip section navigation (2)

Re: Word 2002 - cannot list tables

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: HernĂ¡n QuezadaDate: 2004-12-28 14:31:42
Subject: send odbc
Previous:From: George WeaverDate: 2004-12-23 16:45:43
Subject: Problems with Beta 5 and odbc driver 8.00.00.02

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group