Hi There,

I have been getting the Timeout Expired exception intermittently using LLBLGenPro. So I searched this forum for answers and didn't really find any that helped me out.

Well I did some more investigation and it has nothing to do with LLBLGen and is all to do with SQL Server 2005. Looks like all databases that are created have the AutoClose option defaulted to True!!! This is bad, because that gives SQL server the go ahead to close down the database to save resources if there are no users logged into it for a specified period of time. So if there is a long period of inactivity and some user comes along to request data from SQL Server and the DB is closed then it may take too long for SQL to get everything going in time therefore the Timeout Exception occurs.

So in short, set the AutoClose option to False on all databases.

Cheers, Greg

Hello All, I am using LLBLGEnpro. And when i am trying to import a large XLS file to my Database i am getting the error as

"An exception was caught during the execution of a retrieval query: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."

and when i tried to debug i found the error is

Source "SD.LLBLGen.Pro.ORMSupportClasses.NET11" string Message "An exception was caught during the execution of a retrieval query: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

I tried the option of Setting the AutoClose option of SQL server 2000 as off but then also i am getting this error.

Please if any body can help me regarding this .It would be great.

Regards, Teena