Page 1 of 1

sqlite strange timeout from pool

Posted: Sun 11 Dec 2011 10:21
by shaharw18
Hi.

a webpage displaying a simple list of records from the sqlite database, displays the following error message.
on the dev machine all is good but when uploading the project's files to the hosting server, it gives this message:

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

this is my connection string:
data source=d:\Inetpub\vhosts\formation.co.il\httpdocs\App_Data\db.db;Version=3;Pooling=False;Max Pool Size=100;

setting the pooling parameter to true or false won't influence the situation.


thanks in advanced,
Shahar Weinstein

Posted: Sun 11 Dec 2011 11:40
by shaharw18
I would like to add that this problem popped up in another project i was doing. and there I didn't have the time to deal with it, so I just replaced the devart code lines to ordinary sqlite with datareads etc, and the problem was solved without the need to change the connection string or anything else.

Shahar.

Posted: Mon 12 Dec 2011 07:46
by Shalex
A similar problem was fixed in one of the latest builds of dotConnect for SQLite. Please upgrade to 3.60.258 and notify us about the results.

Posted: Mon 12 Dec 2011 08:13
by shaharw18
it's written in the website about the new version.
but the exec is not updated.
I've just downloaded it, and checked the version.

I'm waiting for the new version,
thanks for the reply

Shahar.

Posted: Mon 12 Dec 2011 16:20
by Devart
Please email to our sales team your license number or registrtion name/email to check the status of your subscription.

Regards,
Devart Support

Posted: Mon 12 Dec 2011 16:46
by shaharw18
I haven't paid for your production, I'm currently testing it in various projects.
does it mean that the last version of the DLL won't be available to the public?

Shahar

Posted: Tue 13 Dec 2011 13:56
by Shalex
You can download a trial of the latest (3.60.258) version of dotConnect for SQLite from http://www.devart.com/dotconnect/sqlite/download.html. I have just checked that the version is updated.