sqlite strange timeout from pool

shaharw18 · Post by **shaharw18** » Sun 11 Dec 2011 10:21

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

shaharw18 · Post by **shaharw18** » Sun 11 Dec 2011 11:40

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.

Shalex · Post by **Shalex** » Mon 12 Dec 2011 07:46

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.

shaharw18 · Post by **shaharw18** » Mon 12 Dec 2011 08:13

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.

Devart · Post by **Devart** » Mon 12 Dec 2011 16:20

Please email to our sales team your license number or registrtion name/email to check the status of your subscription.

Regards,
Devart Support

shaharw18 · Post by **shaharw18** » Mon 12 Dec 2011 16:46

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

Shalex · Post by **Shalex** » Tue 13 Dec 2011 13:56

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.