PC Review


Reply
Thread Tools Rate Thread

Data Access Page timeout problem

 
 
bin
Guest
Posts: n/a
 
      9th Jul 2007
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

 
Reply With Quote
 
 
 
 
bin
Guest
Posts: n/a
 
      10th Jul 2007

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



On Jul 9, 2:18 pm, bin <bin4...@gmail.com> wrote:
> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem saving Access Form as Data Access Page vpman Microsoft Access Forms 0 7th Apr 2006 05:12 AM
Problem with Timeout and Data Access Blocks Adam Flint Microsoft Dot NET 0 15th Feb 2006 07:55 AM
timeout while running an Access Htm page =?Utf-8?B?QW5keQ==?= Microsoft Access 0 2nd Feb 2006 05:51 PM
Data Access Page problem =?Utf-8?B?VEJvZQ==?= Microsoft Access 2 17th Aug 2005 07:16 PM
Data Access Page problem Ronald Microsoft Access 0 6th Jan 2004 08:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:51 PM.