Hi
We have a project that runs fine on our development machine but when we deploy it and run one of the sql statements it returns the error:
Object reference not set to an instance of an object
Error Number: 91
I have narrowed it down to when it is retreiving the first value from the recordset using rs.fields(0).value
The odd thing is that the SQL Statement runs fine directly against the database, the db connectivity is fine as other statements run without problem and they use the same execution code.
Its driving me mad.
My development machine is Windows XP Pro and the deployment machine is Windows 2k3 Server (SBS 2k3).
Any help would be much appreciated.
Thanks
B
We have a project that runs fine on our development machine but when we deploy it and run one of the sql statements it returns the error:
Object reference not set to an instance of an object
Error Number: 91
I have narrowed it down to when it is retreiving the first value from the recordset using rs.fields(0).value
The odd thing is that the SQL Statement runs fine directly against the database, the db connectivity is fine as other statements run without problem and they use the same execution code.
Its driving me mad.
My development machine is Windows XP Pro and the deployment machine is Windows 2k3 Server (SBS 2k3).
Any help would be much appreciated.
Thanks
B