By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,340 Members | 1,370 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,340 IT Pros & Developers. It's quick & easy.

ADODB problems with multiple applications on the same web server

P: n/a
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
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is a self answer for anyone else with this problem. I was able to find
an answer for this myself at
http://support.microsoft.com/default...b;en-us;810098. MSDN
article 810098 stated that this is a framework 1.0 issue but I have the
latest 1.1 .net framework installed and this is still a problem. So look to
this article if your having dll problems in a web server running multilpe
websites read this article. It applies to the 1.1 framework as well.
"Steve Mauldin" <st**********@hotmail.com> wrote in message
news:OA**************@TK2MSFTNGP15.phx.gbl...
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

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.