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

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")

 
%>
mwoolgarAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rlibrandiConnect With a Mentor Commented:
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
 
JonthemoonCommented:
rlibrandi Is Right...

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


-Jonthemoon
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.