Deployment Problems, Object Reference

Server Error in '/myapp' Application.

Object reference not set to an instance of an object.

Line 97: rsID = New ADODB.Recordset()
Line 98:
Line 99: rsID.Fields.Append("ID", ADODB.DataTypeEnum.adBigInt)
Line 100:
Line 101: rsID.Open()


So what is wrong with that? rs = new then as soon as it's referenced it says it's not created. The code works fine on my computer but as soon as I copy it out to the production web server it hiccups on this line. It gives the same error on every page that I have, always when it tries to get data from a created ADODB recordset.

I've tried it on two production servers but I get the same error.

I've had this very page working before on both of the production servers.

Reboot.

I was able to convince an admin to reboot one of the production servers and now it's working. Have to wait till tonight to reboot the other...

This is worse then DLL Hell. Now it's doing the same thing again. I have two web sites on one server one of them was having this problem again (without any changes having been made to it) and so I rebooted the server, the page that was having the error started working, and the page that was working started having the error!! What is going on?!?!

I merged my two web projects into one and now everyhting works. Looks like you can't have two web projects that both use the ADODB.DLL on the same server. As I get better at using the System.data stuff this prolbem should dissapear.