S
Steve Mauldin
I have Two ASP.Net applications running on a windows 2000 Server box. One is
www.abc.com and one is www.dfg.com . They have the same code in them to
connect to the same SQL Server 2000 database using ADODB. I restart IIS on
the server and Browse to the first application and it connects to the
database and retrieves a recordset without a problem. I then Start another
browser window and go to the second application. The query is executed on
the SQL Serverthe ADO RecordSet is not recordset BOF and EOF. My code then
goes into a while not Rs.EOF then it errors on the next line with "Object
reference not set to an instance of an object. " Both the recordset and the
connect is closed in each application and these are standalone web sites.
Any help would be greatly appreciated. Thank you.
If rs.EOF And rs.BOF Then
Err.Raise(30009, "error 9", gSettings.ConnectString & "RecordSet is BOF and
EOF")
Exit Sub
Else
While Not rs.EOF
If UCase(rs.Fields("Value").Value) = UCase("TRUE") Then <==== Code errors
out here
www.abc.com and one is www.dfg.com . They have the same code in them to
connect to the same SQL Server 2000 database using ADODB. I restart IIS on
the server and Browse to the first application and it connects to the
database and retrieves a recordset without a problem. I then Start another
browser window and go to the second application. The query is executed on
the SQL Serverthe ADO RecordSet is not recordset BOF and EOF. My code then
goes into a while not Rs.EOF then it errors on the next line with "Object
reference not set to an instance of an object. " Both the recordset and the
connect is closed in each application and these are standalone web sites.
Any help would be greatly appreciated. Thank you.
If rs.EOF And rs.BOF Then
Err.Raise(30009, "error 9", gSettings.ConnectString & "RecordSet is BOF and
EOF")
Exit Sub
Else
While Not rs.EOF
If UCase(rs.Fields("Value").Value) = UCase("TRUE") Then <==== Code errors
out here