Deployment Problems, Object Reference

[Dmyze]

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.

[Dmyze]

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...

[Dmyze]

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?!?!

[Dmyze]

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.