Moving asp site to new windows server, ADOBD connection error

Hi I have been tasked with moving an asp application to a new se开发者_如何学JAVArver, however I receive the following error:

ADODB.Connection error '800a0e78'

Operation is not allowed when the object is closed.

I am not sure what i'm missing as I don't have much experience with asp. I have registered a dll file with windows moved the DB accross and scoured every forum I can find to look for similar issues, however they all say that there is a coding issue. The site has been running smoothly for 18 months on another server so I don't see how there could be any problem with the code. Thanks in advance.

The most likely cause if it was working previously, is that your connection isn't set up correctly. Perhaps the database is in a different location, perhaps it's using different credentials, perhaps a provider is missing, perhaps an ODBC connection is missing.

The reason you are seeing "operation is not allowed when the object is closed" is likely because there is some "on error resume" type code where your db connection code exists, which is transparently swallowing the connection errors. So the code continues thinking that the connection is open.