I have created several ASP forms using ADO and SQL Server 7.0. I took one of these forms and created a new SQL Server 7.0 Database/Table. The only change to the forms was the reference to the new database/table/fields.

It populates the table on the form with the number of records set in PageSize, but I cannot obtain correct values for any other ADO property values like RecordCount, PageCount and AbsolutePosition. These property values all return –1. We are not having fun trying to resolve this issue – it is as if we have a recordset but nothing else relating to the Recordset Object is available. The connection string and Recordset code appear below.

strConn = "Provider=SQLOLEDB;Server=T22DEV18;Database=QMDS;UID=sa;PWD=;"

Set oProj = Server.CreateObject("ADODB.Recordset")

oProj.PageSize = 3

oProj.Open "Select * from QPR order by QPRNumber" ,strConn,3,3

We are using Visual InterDev 6.0. We were using SP 3 and ADO 2.1 and installed SP 4 and ADO 2.5 with no changes. Again the original forms work and the copies with new a new data source do not.

Tom