How long does it take the query to execute when run from within QA?
-Mike
>Hello everyone.
>
>I am running an ASP page that query against Sql 2000 server and I get the following error:
>
>
>Error Type:
>Microsoft OLE DB Provider for SQL Server (0x80040E31)
>Timeout expired
>/BSTReporting/EffortReport/while2.ASP, line 170
>
>
>Here is my connection string
>
>strConnection = "Provider=sqloledb;Data Source=SQL-01;Initial Catalog=proddb;User Id=bstdba;Password=sqlss"
>
>
>
>When I run the same query inside the Sql Query Analyser I have no problem.
>
>Any help is appreciated.
>
>Thanks,
>Sergio