Data Access Page timeout problem

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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