Data Source Connection Lost after Windows 2000 update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel - 28 Oct 2003 11:27 GMT

I have several mail merge applications running Word 2000
to extract their data from Paradox databases. After
updating the Windows 2000 machines with all the available
updates these applications fail as the link to the data
seems to be deleted. The same applications merging to
Word 2002 are OK. Any ideas what is going on? I really
need to get the Word 2000 machines to work!

Thanks

Reply to this Message

Peter Jamieson - 28 Oct 2003 17:08 GMT

It could be that a Paradox ODBC DSN is removed as a consequence of an update
to the MS data access libraries (MDAC). By default, Word 2002 does not use
ODBC and would not need the DSN.

You could try opening one of the Word documents, starting the VBA Editor,
and use the Immediate window to print the value of
ActiveDocument.MailMerge.DataSOurce.ConnectString, which should tell you the
name of the DSN that Word is trying to use. Then recreate the DSN in the
ODBC Administrator (assuming that the update hasn't actually removed the
Paradox ODBC driver as well).

This does not sound very likely to me (I certainly do not think the upgrades
result in loss of the Paradox ODBC /driver/) but I suppose it is worth
checking.

--
Peter Jamieson
MS Word MVP

> I have several mail merge applications running Word 2000
> to extract their data from Paradox databases. After
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message