ADO Recordset: Object reference not set to an instance of an object

[bernie321]

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

 

[netctl]

are you using asp or asp.net, ADO or ADO.NET?
if asp.net with ado NOT ado.net you will need a copy of adodb.dll in your bin folder

 

[bernie321]

Hi Netctl

Thanks for your post.

I am using ADO, not ado.net and I already have a copy of adodb.dll in my bin folder.

Thanks
B

 

[ca8msm]

Rather than using a recordset, I would suggest using a DataReader ot DataTable as in faq855-5662

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.