Mail Merge in Cache Database

[Guest]

Hi,

I'm trying to do mail merge to word document where the data source is from a
database called "Cache" from intersystems using this code:

public CacheConnection cnCache;
string cacheConnectString =
ConfigurationManager.AppSettings["CacheConnectionString"];

cnCache = new CacheConnection(cacheConnectString);
cnCache.Open();
Object oConnection = cnCache;
Object oQuery = "SELECT GivenNames,Surname from cvPeople.People WHERE ID=1";

Object oSubType = Word.WdMergeSubType.wdMergeSubTypeWord;

//Open the data source and merge the fields

wrdMailMerge.OpenDataSource("", ref oFileFormat, ref oMissing, ref oMissing,
ref oTrue, ref oMissing,ref oMissing, ref oMissing, ref oFalse, ref oMissing,
ref oMissing, ref oConnection, ref oQuery, ref oMissing, ref oMissing, ref
oSubType);

But it doesn't work !!? because "oConnection" should be the DNS connection
and I don't know how to do it in Cache!
does some body knows how to do it? or if not does any one how to use a Data
Set as the data source, because I know how to fill a DataSet from Cache and
from there I could just use the DataSet to mege the Document.


Thks

 

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

The technique you are using (COM interop with Office) is not recommended for
use with ASP.NET, as explained here by Microsoft:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757

There are some good 3rd party products that would probably be better
options.
Here are a couple that should work:
http://SteveOrr.net/reviews/AsposeWord.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

VSTO should also work:
http://msdn2.microsoft.com/en-us/office/aa905533.aspx