Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Problems and bugs
 Operation is not allowed when the object is closed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

craigedmonds
Starting Member

Spain
4 Posts

Posted - December 29 2014 :  12:31:35  Show Profile  Reply with Quote
We have a hosting client who has had vpasp running on a windows 2008 server for the last 3 years no problems.

We have just migrated their site to a windows 2012 server running plesk and now when she tries to see the site it gives the following error:

ADODB.Connection error ''800a0e78''
Operation is not allowed when the object is closed
/shop$db.asp, line 1439

Line 1439 shows the following code: Set irs=conn.execute(isql) so looks like its opening a connection.

We get the same message when trying to access the admin and various other pages that calls this connection.

We have checked...

- temp dir permissions
- database permission (access db full control IUSR)
- application pool is running 32bit mode

All we have done is move the site to a new server so theoretically should work right off the bat.

serjtankian
VP-CART Super User

Armenia
378 Posts

Posted - December 30 2014 :  07:06:07  Show Profile  Visit serjtankian's Homepage  Reply with Quote
The error message "Operation is not allowed when the object is closed." normally it is because the application fail to connect to the database.

try to double check shop$config.asp configuration






*serj*
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts

Posted - January 05 2015 :  06:30:42  Show Profile  Reply with Quote
Hi,

as serj has suggested, please check the path to the site in the files shop$config.asp in the root folder and shop$config.asp in the admin folder. Check that the drive letter matches with the new server.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - January 08 2015 :  22:57:33  Show Profile  Reply with Quote
Operation is not allowed when the object is closed , can be 2 issues i believe guys:
1. connection db string invalid
2. permission db issue
if u sure no.2 is reset , strongly issue will be no.1.
can u debug first: http://p2p.wrox.com/classic-asp-databases/44751-get-error-adodb-recordset-error-800a0e7d.html
diego.


Go to Top of Page

g3nnin
VP-CART Super User

209 Posts

Posted - January 09 2015 :  12:47:24  Show Profile  Reply with Quote
Hi,

I would recommend to contact the database admin and ask them the connection string to your new database. Then check or compare with the ProcessSQLServer routine in shop$db.asp.

Have you also tried changing these configs in shop#db.asp?

const xSqlOLEDb="No"
const xSqlNative="No"


Hope this helps!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00