Server-side ASP script problem

[ChrisProg]

Hi All,

I have set up a small project in which there are a number of htm and asp files. I wish to use server-side scripts for database maintenance which are invoked by design-time control buttons. The recordset control points directly to the table required, with advanced settings for server-side/dynamic access.

Scripts are attached to the buttons as required, and to enter row event.

The asp with the database recordset and bound controls fails during loading with the following error shown in the browser:-

+++++++++++++++++++++++
"
ADODB.Properties error '800a0cc1'

ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.

/CompassPilot2/_ScriptLibrary/Recordset.ASP, line 462
"
+++++++++++++++++++++++

The line at fault is the one shown below with the 'true' value.

+++++++++++++++++++++++
"
_ScriptLibrary
Recordset.asp


// force AbsolutePosition to work in server-side cursor for SQL
if (this._rsADO.CursorLocation == 2)
this._rsADO.Properties('IRowsetScroll') = true;
"
+++++++++++++++++++++++

If I switch to client-side scripting, the error does not occur and the program 'sort of works' logically, but of course it does not action the buttons_click events.

Has anyone a solution or advice on how to proceed?

Regards

ChrisProg

 

[MerlinB]

Ensure the table has a unique key.

Try changing the Recordset source from a table to a SELECT * FROM <TABLE>.

 

[MerlinB]

Also see the MSDN Support Article:

http://support.microsoft.com/support/kb/articles/Q248/0/02.ASP