Connection Timeouts.

Posts   
 
    
MT10
User
Posts: 4
Joined: 28-Dec-2004
# Posted on: 28-Dec-2004 11:52:11   

I do have connection timeouts using LLBL. It is not the case when using a standard SQL Client access. How could I enhance my connection string ? I already added to it: Max Pool Size and Min Pool Size and connection time out.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39922
Joined: 17-Aug-2003
# Posted on: 28-Dec-2004 13:45:10   

Do you have connection timeouts using sproc calls or also using normal llblgen pro activity like fetching an entity?

You can set the timeout (not for firebird) using: Selfservicing: DbUtils.CommandTimeOut (static/shared) Adapter: DataAccessAdapter.CommandTimeOut (instance property)

Frans Bouma | Lead developer LLBLGen Pro
Posts: 112
Joined: 09-Aug-2004
# Posted on: 28-Dec-2004 13:46:35   

LLBLGen will use what ever connection string you specify in the configuration file, by default it is in key Main.ConnectionString. To prolong the timeout put a ; at the end of the string and then put

Connect Timeout = XX

or

Connection Timeout = XX

where XX is your timeout. I couldn't fully understand your question if you knew this or not. Doesn't hurt to say.

However if you are timing out only when using LLBLGen, that is very strange. I have never had any issues with it. The generated code connects to SQL Server probably the same way you would. I would check security and permissions to see if there are any deadlocks