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.