SQL Server problem with new driver version 3.00.1

ste · Post by **ste** » Mon 06 Feb 2006 09:58

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.

Ikar · Post by **Ikar** » Mon 06 Feb 2006 12:04

Most possible you set ConnectionTimeout value. From last build this value affects as CommandTimeout too. Try to increase this value.

ste · Post by **ste** » Mon 06 Feb 2006 13:21

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.

Ikar · Post by **Ikar** » Tue 07 Feb 2006 14:00

Please download latest build of DbxSda (3.00.2).