Solved

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

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
asp Google Map 2 61
Web Easy Professional 10 Embedded Facebook 1 41
help thx 6 22
SP converting date time to date and time separately 2 19
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.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

749 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