RDS Issue in Internet Explorer

Reply

Join Date: May 2004
Posts: 1
Reputation: marlongill is an unknown quantity at this point 
Solved Threads: 0
marlongill marlongill is offline Offline
Newbie Poster

RDS Issue in Internet Explorer

 
0
  #1
May 17th, 2004
I am currently working on a system developed some 3 years ago by a developer who used to work for our company. It is an ASP/DHTML administration system for accident reporting. The main page of the site is written in HTML and consists of a set of forms providing the user with the ability to enter details of the accident.

On this page there are half a dozen RDS data controls which are bound to the various forms in order to establish a link with the SQL server back-end. The data source of these RDS data controls are a set of ASP pages which contain XML persisted versions of the recordsets used for the page.

The problem I am having is that after a period of inactivity of roughly 13 minutes, the save option on the page (which calls the RDS Update method) causes the following error to be displayed in a VBScript message box:

'The requested action cannot be performed when the object is closed.'

I have checked the timeout value for the ASP session to ensure that the asp session is not timing out, but this is currently set to 60 minutes and is hence not the problem.

I have checked the status of the RDS recordset prior to the update being called and it returns 0 (zero). The only thing I can think of is that the RDS data controls are timing out.

Is this the case, and is there any way to set this timeout period, as I cannot find a property that would accomplish this. The only property I could find is called InternetTimout, but this only seems to apply to the amount of time allowed to execute a query against the database.

Any advice would be greatly appreciated as I have a very disappointed customer and am pulling my hair out!!!!
Reply With Quote Quick reply to this message  
Join Date: Jul 2004
Posts: 32
Reputation: RobUK is an unknown quantity at this point 
Solved Threads: 1
RobUK RobUK is offline Offline
Light Poster

Re: RDS Issue in Internet Explorer

 
0
  #2
Jul 13th, 2004
you need to use the command timeout in your connection string as well as the internettimeout property
something like this:
  1. RDSControl.Server = "http://yourdomain"
  2. RDSControl.InternetTimeout = 1200000
  3. RDSControl.Connect = "Provider=sqloledb;" & _
  4. "Data Source=whatever;" & _
  5. "Initial Catalog=northwind;" & _
  6. "User Id=sa;" & _
  7. "Password=;" & _
  8. "Command Properties='Command Time Out=1200'"

This will set the timeout to 20 mins
Rob - DMOZ Editor
Web Design Forums - Free website critiques. Web design + SEO Advice
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC