Generating with mailmerge

Aspose.Words Product Family
1

Dear Aspose,

We notice a problem, when we use mailmerge with a ado recordset.
the ASP.NET pool hangs.

Our system is a W2003 server with standard ASP.NET instalation.

Can you help us?

Greetings,

W. Burggraaf
ESDEKA B.V.

2

Hi,

Thank you for considering Aspose.

Do I understand you correctly - you use classical ADO + ASP .NET? Why not ADO .NET?

Could you please post or attach a sample code causing the error?

3

No, i don’t use ASP.NET because a disconnected envoirement in our situation is not usefull.

It simply this.

Dim doc As Document = New Document(System.IO.Path.Combine(Base.Dirs.psDL, TmplName))
‘
rst = New ADODB.Recordset
sql = “SELECT * FROM ****************************”
rst.Open(sql, Base.DB.cnn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)
doc.MailMerge.ExecuteWithRegionsADO(rst, “tblBezwaar”)
rst.Close()
’
rst = New ADODB.Recordset
sql = “SELECT * FROM ****************************”
rst.Open(sql, Base.DB.cnn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)
doc.MailMerge.ExecuteWithRegionsADO(rst, “tblBezwaar2”)
rst.Close()
'
doc.Save(Base.Dirs.psDL & Session.SessionID & “.doc”)

4

We have reproduced your code and it works just perfectly. Could you please:

1. Make sure you are using the latest version of Aspose.Word;
2. Provide more detailed explanation of the issue (does the pool simply hangs, without any exception thrown? By the way, which pool do you mean - ASP .NET application pool or something else?);
3. If possible, send or attach your document template and data sample to let us have a look?