IIS 6.0 and disappearing HTML Elements

ASP pages that use RecordSets like this:

recordSet.Open Session("RepQryStr"), connection, 3

where 3 = adOpenStatic, work on the setup of
Windows 2000 Server/IIS 5.0, but on Windows 2003 Server/IIS 6.0 I see that HTML elements disappear after attempting the query.

The strange thing is, on other ASP pages I just changed the cursor type to 0 = adOpenForwardOnly, and it works, but on another ASP page it does not and plus makes HTML elements disappear!

Anyone experience this oddity with IIS 6.0?

I have a theory on the disappearing html elements issue,
I imagine that ASP is a new version on Windows Server 2003, and there are thus new rules and behavours. I am just experiencing some of them.

I have noticed this with ASP and Windows Server 2003 and I detail it below:

When you use a particular cursor type for a RecordSet, and you attempt to call the RecordCount property, or the MoveFirst method, and that cursor is not supposed to use those properties/methods, you won't get an error, but you may get very unpredictable results.

I know this because I tried to trap errors by using
"On Error Resume Next" and calling an errorHandler subroutine,
and Err.Number was zero.

This has to be helping someone.

I'd review your asp code. Everything you are discussing is ADO related, not necessarily ASP related. IIS6 doesn't have any problems with asp that I'm aware of.

You might wander around the ADO reference documentation for more description of cursor type, lock type, recordcount, etc.

http://msdn.microsoft.com/library/e...rsreference.asp

The fact that there was different behavior on the 2 setups, same web page code, indicates to me there are subtle differences between the ASP DLL with the new Windows Server 2003.

Looks like a stricter policy on what is allowed with the cursors, because I am "getting away with it" on Windows 2000 Server.

So whether I was using the cursors exactly in the correct way on Windows 2K or not, it was working, and the html elements were not disappearing.

Recordsets, cursors and such are components of ADO, not ASP. You may have different versions of ADO on the different machines. MDAC is downloadable from http://www.microsoft.com/data if you need different versions.