View Single Post
  #1 (permalink)  
Old June 9th, 2003, 07:18 AM
mcinar mcinar is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , NY, USA.
Posts: 141
Thanks: 1
Thanked 0 Times in 0 Posts
Default "Beginning E-Commerce with Visual Basic, ASP, SQL

Hello mcinar,

Forum member mcinar has posted a new topic to the P2P_Feed forum.

You are being notified because you are subscribed to this topic.

Topic: ASP
Message:
------------------------------------------------------
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

Site.asp

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; " & _
          "SERVER=localhost"
   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.

:)
__________________
MCinar

Love all the creatures because of the creator.