Wrox Programmer Forums
All Other Wrox Books Do you have a question about a Wrox book that isn't listed anywhere on p2p.wrox.com or where the forum is locked? Here's a forum to post questions about any other Wrox book so that other readers or one of the authors can help you with your questions. IF YOU ARE LOOKING FOR CODE DO NOT ASK "Where can I find the code for this book?" That question is answered here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the All Other Wrox Books section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 8th, 2003, 08:52 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 141
Thanks: 1
Thanked 0 Times in 0 Posts
Default ASP

Hi Everyone,

The following codes from
"Beginning E-Commerce with Visual Basic, ASP, SQL Server 7.0 and MTS" book.

I am getting the following error while running the "Admin\default.asp",

Error Type:
ADODB.Connection (0x800A0E78)
Operation is not allowed when the object is closed.
/JoCoffee/site.asp, line 50


Set query = Visit.Catalog.GetAllDepartments (50 th line)

Function Visit
   ' Do we have one?
   If IsEmpty(m_visit) Then
       ' Create an instance of a Visit Object...
       Set m_Visit = server.CreateObject("WroxCommerce.Visit")
       m_visit.Configure g_sitename, g_domainname, "driver=SQL Server; " & _
           "DATABASE=JoCoffee; UID=JoCoffeeWeb; PWD=eermlate; " & _
   End If
   ' Return the Visit object back...
   Set Visit = m_visit
End Function

Function Visit: m_Visit.Configure works fine. This shows that
"WroxCommerce.DLL" is also fine.

Once it executes "Set query = Visit.Catalog.GetAllDepartments" line,
the "Operation is not allowed when the object is closed" message comes up. What causes this error?

Thank you.


Love all the creatures because of the creator.

Similar Threads
Thread Thread Starter Forum Replies Last Post
send parameters from asp page to an asp.net form hastikeyvan ASP.NET 1.0 and 1.1 Basics 2 March 29th, 2008 01:32 AM
using asp.net web user control in asp 3.0 App i_shahid Classic ASP Professional 0 January 8th, 2008 07:32 AM
Custom HTTP 404 Problem w/ASP to ASP.NET kwilliams ASP.NET 2.0 Professional 7 November 26th, 2007 04:17 PM
Upgrading ASP w/ SQLserver 2000 to ASP.NET w/2005 cJeffreywang ASP.NET 2.0 Basics 1 April 5th, 2007 11:30 PM
Porting a sa,ple ASP CR viewer app to ASP.NET jhansen42 Crystal Reports 0 August 29th, 2003 10:26 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.