Data Access Page timeout problem

B

bin

Hi, I am getting data via Data Access Page from a stored procedure on
a SQL-Server 2000. With growing tables I get the error message:
"Timeout expired". Is there a way to change the settings to eliminate
this problem? I have already optimized the stored procedure.

Thanks a lot
 
B

bin

I figured out how to do this by myself, add
MSODSC.Connection.CommandTimeout=0 in scripts, thanks anyway
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Active Content in this file is blocked issue 1
Query Timeout error 0
Query Timeout Expired Eror 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
How do I prevent "Timeout Expired" 4
Page numbering with Merged Document and IF statements 1
Server timeout expired 3

Top