Application error: "Set" assignment statements are no longer supported

[J. Muenchbourg]

The following line in part of my asp-sql block:

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

creates an application error: "Set" assignment statements are no longer
supported

(in this particular block):
<%
Dim rs, strSQLd
Set rs = Server.CreateObject("ADODB.Recordset")
strSQLd = "Select * FROM category"
rsd.Open strSQLd, dbc
While Not rs.EOF
%>

I'm using this in an aspx file so that i can take advantage of the
paging and some of the other asp.net objects in the application. What is
a suitable replacement for "set" assignments?

thanks
Muench

 

[Chris Dunaway]

What is a suitable replacement for "set" assignments?

Just don't use Set:

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