We have a database that was created with release 6.5 in Spring 2006. The only thing in this database is one agent. When manually ran, this agent accesses a few SQL tables, gathers certain data and posts all of this to a specific SQL table. When this agent was written, we were using SQL Server 2000…
We upgraded to Domino 7 this summer. After the upgrade , when we ran the agent, it worked fine.
A couple of weeks ago, we upgraded our server to SQL Server 2005. Now, when we run the agent, we get no records returned…actually that’s not entirely true. If I tell it to select a specific record in the SELECT statement, it will return that one record. If I remove that piece, we get no results and this error: “213: Microsoft OLE Provider for SQL Server: Timeout expired occurred at line 99”
The only thing that changed was the upgrade of the software (both Domino and SQL). No code was changed at all…except for adding the tiny bit to limit it to one record, and that was just for testing so it was removed.
Also, we do have a timeout line in the code. We have tried everything from 0 to 5000…originally it was just set to 300.
Our Domino server is running Windows 2003 Standard Edition with Service Pack 1 and our SQL server is running Windows 2003 R2 Enterprise Edition (x64).
I have searched this forum, the Microsoft forum and Google for two days and I can’t find anything that could be wrong. I didn’t post the code since it has worked perfectly up until we upgraded to SQL Server 2005, but if anyone needs to look at it, I will be a happy to post it.
Does anyone know of any issues that may cause this? Any guesses will be greatly appreciated…