Hi all,
I am having problems with reporting off multiple Notes databases from a Crystal report. This is my setup (on a Windows 2000 Server machine):
Crystal Reports XI
SQL Server 2000
Lotus NotesSQL 8.0
Lotes Notes 8.5.1
I have a Crystal report which accesses one Notes database via a linked server in SQL Server. This report runs without problems.
However, another Crystal report which accesses three different Notes database via three linked servers fails intermittently with the following error:
Failed to retrieve data from the database. Details: [Database Vendor Code: 7399 ].
SQL Server is used to combine the data from the linked servers using UNION in a SQL view.
This seemed to suggest that the number of linked servers was an issue so I created a Crystal report which accesses twelve different Notes databases. This report ran fine a few times on its own. However, when three copies of it were scheduled to run at the same time it failed most of the time.
Does this indicate a limitation of NotesSQL/Notes, i.e. max number of client connections?
Thanks in advance,
Kui Meng Ng.