Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Using Word 2000's mail merge feature with Oracle as data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mandy - 15 Apr 2004 18:26 GMT
We have recently discovered that Microsoft Word 2000 (which we are currently using) has the mail merge feature to connect to a Oracle database using MS Query and ODBC drivers. We would like to know if there are any organizations out there using this feature with Oracle and if there have been any problems encountered.
Peter Jamieson - 15 Apr 2004 21:25 GMT
I have not used it for a while, but
a. there are at least two different ODBC drivers for Oracle: the Microsoft
ones, and the Oracle ones.
b. The Microsoft drivers only claim to support a fairly old verson of
Oracle (I cannot remember off the top of my head, but it is probably either
version 6 or 7, compared to the current Oracle database version 10i)
c. I do not know what version of its database Oracle supports via ODBC
nowadays.
d. In my limited experience, Microsoft's ODBC drivers seemed less dependent
on an up-to-date version of Oracle SQL*Net networking environment than
Oracle's drivers, and also seem to have less cryptic keywords and to be be
marginally better documented than Oracle's drivers. In short, it seemed
easier to get a reliable result using the MS drivers than Oracle's.
e. You wil probably encounter problems if you have any character set
encoding issues that are even slightly atypical (i.e. non-ANSI) or need any
large data such as memo fields.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> We have recently discovered that Microsoft Word 2000 (which we are currently using) has the mail merge feature to connect to a Oracle database
using MS Query and ODBC drivers. We would like to know if there are any
organizations out there using this feature with Oracle and if there have
been any problems encountered.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.