URGENT! Problem migrating an ASP website onto Windows Server 2003 (Recordset Cursor/Bookmarks)
-
I have a large web application (written with ASP/VBScript) that has been hosted on Windows 2000 Server up until now, but now I have to migrate it over to our new Windows 2003 Server. Microsoft doesn't seem to believe in backwards compatibility anymore, and so I'm having problems. A whole bunch of the code deals with paged recordsets, such as the absolutepage property, and because of what we'll be doing in a month or so, it's not feasible right now to actually go through making and testing changes to the source code. The problem occurring (only on Win2k3, not Win2k) is this:
ADODB.Recordset error '800a0cb3' Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.I have tried changing the database code to both static and dynamic cursors, and installing MDAC 2.8, both to no avail. Why on earth does this cause an error on Windows Server 2003 but not on Windows 2000? What can I do to make it work? NATHAN RIDLEY Web Application Developer email: nathan @ netlab.com.au [remove the spaces before and after the @ symbol] -
I have a large web application (written with ASP/VBScript) that has been hosted on Windows 2000 Server up until now, but now I have to migrate it over to our new Windows 2003 Server. Microsoft doesn't seem to believe in backwards compatibility anymore, and so I'm having problems. A whole bunch of the code deals with paged recordsets, such as the absolutepage property, and because of what we'll be doing in a month or so, it's not feasible right now to actually go through making and testing changes to the source code. The problem occurring (only on Win2k3, not Win2k) is this:
ADODB.Recordset error '800a0cb3' Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.I have tried changing the database code to both static and dynamic cursors, and installing MDAC 2.8, both to no avail. Why on earth does this cause an error on Windows Server 2003 but not on Windows 2000? What can I do to make it work? NATHAN RIDLEY Web Application Developer email: nathan @ netlab.com.au [remove the spaces before and after the @ symbol]Hope it will work. http://support.microsoft.com/default.aspx?scid=kb;en-us;255707 Cheers, The Phantom.