Does anyone know the common causes of this error?

[nomofoxpro]

ADODB.Connection error '800a0e78'

Operation is not allowed when the object is closed.

Please note that this only happens on some of our servers. All the servers are running SSL.

Thanks in Advance

 

[nomofoxpro]

I'm sorry I forgot to tell you that it is making a connection to a SQL 7 database. For some reason the connection object is closing when a command is sent to it. This is all the info I have.

Thanks again

 

[palbano]

Is the error consistent or random?

> Please note that this only happens on some of our servers.

Are all of the servers running the same code and connecting to the same database?

Is the latest version of MDAC installed?
What OS?

-pete

 

[nomofoxpro]

The error is random 30 - 50% of the time in Netscape. 5% of the time in IE.

Same Code, Different Database.

MDAC
The Latest Version of MDAC is installed.

OS
Running on NT Server 4.0.

 

[caf]

Hi

"The error is random 30 - 50% of the time in Netscape. 5% of the time in IE. Same Code, Different Database"

hmmm....

Different database => Is it different format eg oracle & sql server or is it both sql server?
Is it two different versions (if the same type of rdms)?

Are you using the same dataaccess components on all servers and are they they the same versions.

The problem could be unsupported properties are being set & or queried and error is raised.

Check the application log (Event log viewer)

I had that error on two applicaiton servers.
I resolved it by restructering my routines into performing specific actions.

The problem (I can vouch from experience) is data access.

The first thing you should do is check the pemissions on the databases to ensure they co-incide.
Check the profiles of both dbs
These have to be exactly the same. Your data access should also be exactly the same (even if you have to recompile to make sure.)

Is data coming back from the server/rdms where the error is originating from? I doubt you'll get data when that error occurs as it's a data access/connection related error.

Hope this helps
caf