Solved

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

Posted on 2004-08-13
2
888 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
increase words that display in widget 6 77
Form Processing in PHP 11 42
Scientific articles behind a login? 6 27
Best environment for cross platform web development? 5 45
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
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:
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

810 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