Re: Word mail merge

["Jim Franz" <franz400@xxxxxxxxxxxx>]

fuzzy memory... but I implemented a Word merge project in a small office
on 8 pc's. Six worked fine, and 2 had similar problems to yours, although I
don't remember exact msgs. In one case, after trying a multitude of things,
the network guy uninstalled CA, removed and reinstalled the MS DSN stuff,
then reinstalled CA and svc pack - it worked. He had found a MS Tech tip
about downlevel MS odbc stuff having problems (nothing mentioned Client
Access), but I "think" there is something to:  what is loaded on the pc at 
the time
CA installed that matters. Has been running fine since.
The other pc had parts of 2 versions of CA in the registry (and tn5250 
worked fine,
but not odbc) and worked after uninstall, clean registry, reinstall CA, svc 
pack.

good luck
jim franz

----- Original Message ----- 
From: "Bill" <bubbzbill@xxxxxxxxx>
To: "PC Technical Discussion for iSeries Users" <pctech@xxxxxxxxxxxx>
Sent: Wednesday, August 23, 2006 5:51 PM
Subject: Re: [PCTECH] Word mail merge


> Steve McKay wrote:
> > I am receiving the message "Unable to obtain list of tables from the data
> > source" when attempting to use an ODBC connection to retrieve data into 
> > MS
> > Word 2003 SP2.  Our iSeries is at V5R2M0.  My iSeries Access is V5R2M0
> > SI04484.
> >
> > I trying to mail merge from an iSeries DB file into a Word document.  I 
> > have
> > tried User, File, and System DSNs with the same results.
> Steve,
>
> I've also had problems with Word and Mail Merge accessing data via the
> Client Access ODBC driver.  IIRC, I could get the original creation to
> work fine, but any attempt to retry resulted in errors.  I finally
> resorted to using MS/Query inside of Excel and then merge the
> spreadsheet data into Word and it has worked fine since.
>
> I'm on V5R2 as well, but I'm using Word 97; so it's somewhat safe to say
> a driver problem.  I don't do enough of the mail merge to research a
> solution any further.
>
> Bill
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.