<div>
Sorry, meant to say try setting the ASP timeout, as opposed to an ODBC timeout.<br />

</div>


Sorry, meant to say try setting the ASP timeout, as opposed to an ODBC timeout.


<div>
No, you were right the first time. .CommandTimes=600 does the trick.
</div>


No, you were right the first time. .CommandTimes=600 does the trick.

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
My ODBC driver &nbsp;(called in ASP) is timing out &nbsp;my queries before they're done (their statistical queries on lots of data, and take about 3 to 4 minutes to run), but I can't see anywhere in the ODBC config snapin to set the timeout period. Can you help?<br />
<br />
(MS SQL 2000)
</div>
</div>


Hi Experts

My ODBC driver  (called in ASP) is timing out  my queries before they're done (their statistical queries on lots of data, and take about 3 to 4 minutes to run), but I can't see anywhere in the ODBC config snapin to set the timeout period. Can you help?

(MS SQL 2000)

How to extend the System DSN timeout period

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.