pao
04-11-2003, 03:48 PM
Hello to everybody.I am writing the code for a search engine,everything is allright except the following bit of code:
<%
Set adoRec = Server.CreateObject( "ADODB.Recordset" )
sqlString = "SELECT DISTINCT ID FROM Master_Records "
sqlString = sqlString & "WHERE ID=1 "
sqlString = sqlString & "ORDER BY ID"
Set catRS = Server.CreateObject("ADODB.Recordset")
catRS.Open sqlString
%>
It gives the following error:
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
CatList.asp, line 7
Can anybody tell me what is wrong ;Thank you all
<%
Set adoRec = Server.CreateObject( "ADODB.Recordset" )
sqlString = "SELECT DISTINCT ID FROM Master_Records "
sqlString = sqlString & "WHERE ID=1 "
sqlString = sqlString & "ORDER BY ID"
Set catRS = Server.CreateObject("ADODB.Recordset")
catRS.Open sqlString
%>
It gives the following error:
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
CatList.asp, line 7
Can anybody tell me what is wrong ;Thank you all