ADODB.Recordset error '800a0bb9' in Classic ASP Page in IIS 7

[mstams]

Hello. I am migrating a classic ASP web application with Access database from IIS6 to IIS 7 and have run into the following error:



ADODB.Recordset error '800a0bb9'


Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


This error occurs when trying to set the Recordset.PageSize property as follows:


set rs = Server.CreateObject("ADODB.Recordset")


rs.cachesize=20


rs.open strSql, my_Conn, 3


if not (rs.EOF or rs.BOF) then


rs.movefirst


rs.pagesize = strPageSize ' <==== Error happens here


maxpages = cint(rs.pagecount)


rs.absolutepage = mypage


end if


I am sure that the SQL statement and connection string are valid as they work fine on the IIS 6 site and other queries against the same Access database(same connection string) work on the new IIS 7 site.


It appears to me that something is different with the way the ADO.Recordset is working in IIS 7.


Anyone else have this issue or know of a workaround?


Thanks.

[raymondp]

Try adding the adovbs.inc to your web application. I found an article pertaining to this error message. Might want to check this out. http://www.4guysfromrolla.com/webtech/faq/Beginner/faq7.shtml

rcp
DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[mstams]

rcp [DASP] said...
Try adding the adovbs.inc to your web application. I found an article pertaining to this error message. Might want to check this out. http://www.4guysfromrolla.com/webtech/faq/Beginner/faq7.shtml


I didn't mention it before, but the application already has included a subset of the ADOVBS constants, so I don't think that's it.

I have seen that suggestion before. Thanks.

[wisemx]

Do you have spaces in any of the data field names?
I've seen recordsets in ASP break because of that with this same error.