I'm testing an ODBC application (to SQL Server 7) and everytime a particular query is executed from Silk, I get a time out error from the ODBC driver. This can be under load or using Try Script (1 user).

The query only takes 7 seconds to run, so I can't understand why it's timing out.

I've tried the application manually and fired the SQL through Query Analyser and they don't time out, it's just Silk.

Any ideas why this might be the case.

Thanks in advance.