800a0cc1 error

[Sarky78]

I am getting the above error when i try to access a page that is DB driven. The line that it is failing on is an if statement to check is a value is 1 or 0. The field is in the database and has informaton in it. The database is in SQL 7 and the field name is override. Is this a reserved word in SQL 7? I have had a look on technet for this error but none of the articles match the probelm that i am having. this is the actual error that i am receiving:

ADODB.Fields error '800a0cc1'

ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application

any ideas ?

 

[Cirrus9]

Usually this error occurs if the DB Field is not spelled correctly or if you are doing joins and the table is not referenced correctly.

 

[Sarky78]

I have found the problem.

What is was we have got a server that i have the ODBC source pointing to, this is where the database is in SQL 7. This for some reason or another is setup to publish to subscribers on the server that the website files are on, this database is out of date and does not have the above fields in it. For some reason, this database is being accessed even though the IP address of the DB server is being specified.

Weird. anyone experienced this before ?

thanks for your help anyway !