Page 1 of 1

SQL Server problem with new driver version 3.00.1

Posted: Mon 06 Feb 2006 09:58
by ste
We have been using DBExpress SDA for sometime now and it has been working well. I have just downloaded DBExpress SDA (version 3.00.1) for compatibility with SQL2005 and since using this version I now frequently get a 'timeout expired' message when our applications performs some time consuming SQL queries.
I am using Windows XP and SQL 2000 at present.
I have tried changing the ODBC timeouts but I guess it doesn't use these.

Posted: Mon 06 Feb 2006 12:04
by Ikar
Most possible you set ConnectionTimeout value. From last build this value affects as CommandTimeout too. Try to increase this value.

Posted: Mon 06 Feb 2006 13:21
by ste
Ikar wrote:Most possible you set ConnectionTimeout value. From last build this value affects as CommandTimeout too. Try to increase this value.
Where can I set these values? I can't find them anywhere.

I can only find the ODBC timeout value, but I've changed this and it made no difference.

Posted: Tue 07 Feb 2006 14:00
by Ikar
Please download latest build of DbxSda (3.00.2).