Solved

ASP: Connection error '800a0e79'  - Operation is not allowed when the object is open.

Posted on 2004-08-13
2
887 Views
Last Modified: 2008-01-09
Hi

I'm having a problem with the 800a0e79 error.
Any suggestions would be great - cheers

Woolly


*************************************************************

The ASP file is as follows:

<%@ Language=VBScript %>
<!--#include file="connection.inc" -->

<%
  conStr.ConnectionTimeout  = 0
  conStr.CommandTimeout = 0
 
  conStr.Open 'see inside the include ="dsn=Autowired;uid=Autowired;pwd=polkado98t;"
  cmdCommand.CommandType =  1
  Set cmdCommand.ActiveConnection = conStr
  cmdCommand.CommandText =  "update [user] set sent=0"
  cmdCommand.execute

%>
<html><body>
Sent flagged cleared for all users.
</body></html>

*********************************************************
My Include files is:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""

'below is an explicit connection
Dim conStr       'connection object          
Dim strsql       'sql string
Dim cmdCommand
Dim objFSO, fileStream
 
Set cmdCommand  = Server.CreateObject("ADODB.Command")
Set conStr = Server.CreateObject("ADODB.Connection")
conStr.Open "dsn=test;uid=me;pwd=;"

'''''''''''''''''''''''''' recordsets
set recSet = Server.CreateObject("ADODB.Recordset")
set rsCount = Server.CreateObject("ADODB.Recordset")
set rsCount_numRows = Server.CreateObject("ADODB.Recordset")
Set rsUsers = Server.CreateObject("ADODB.Recordset")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")

 
%>
0
Comment
Question by:mwoolgar
2 Comments
 
LVL 4

Accepted Solution

by:
rlibrandi earned 50 total points
ID: 11791924
You're opening the connection in the include file:

>>conStr.Open "dsn=test;uid=me;pwd=;"<<

Then trying to open it again after you include your file:

<!--#include file="connection.inc" -->

<%
  conStr.ConnectionTimeout  = 0
  conStr.CommandTimeout = 0
 
>>  conStr.Open 'see inside the include ="dsn=Autowired;uid=Autowired;pwd=polkado98t;"<<
0
 
LVL 3

Expert Comment

by:Jonthemoon
ID: 11793302
rlibrandi Is Right...

Too bad I can't add anything I won't get points ;-)


-Jonthemoon
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now