using stored procedures error

Printable View

08-17-2001, 04:16 PM
Leslie Taylor

using stored procedures error

I have decided to try the stored procedure feature of ASPDB and I receive the following error. I have run the stored procedure through other means.

Thanks
Les

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/GLCloseChecklist/ChecklistSupervisorsp.asp, line 17

<html>

<head><title>Monthly JE Checklist by Supervisor</title></head>


<%

Set MyDb = Server.CreateObject("AspDB.EP")
MyDb.dbStoredProcCmdParams="usp_RetrieveJourna lEntries,4;@Year,3,1,4,2001;@Month,3,1,2,6; @Employee,200,1,50,'';@Supervisor,200,1,50 ,'Cari Gutheil';@Filter,200,1,10,'complete'&# 34;
MyDb.dbDBType="SQL"
MyDb.dbDSN = "file name=" & udlPath & "GL_EOMIGT_GL_EOMAdmin.udl"
MyDb.dbUnit = 11305
MyDb.DbMode = "grid"
MyDb.dbNavigationIcon="std"
MyDb.dbGridInc = 10

MyDb.aspDBEP
set MyDb = Nothing
%>
</body>

</html>
08-17-2001, 05:16 PM
Frank Kwong

using stored procedures error (reply)

wow.. ASPdbEP !! can you get a more updated copy ? USe the Designer and try to do the PUBS SP or ORacle's SP and see whethere you can get it to work. Checkout the examples also.

------------
Leslie Taylor at 8/17/01 5:16:50 PM

I have decided to try the stored procedure feature of ASPDB and I receive the following error. I have run the stored procedure through other means.

Thanks
Les

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/GLCloseChecklist/ChecklistSupervisorsp.asp, line 17

<html>

<head><title>Monthly JE Checklist by Supervisor</title></head>


<%

Set MyDb = Server.CreateObject("AspDB.EP")
MyDb.dbStoredProcCmdParams="usp_RetrieveJourna lEntries,4;@Year,3,1,4,2001;@Month,3,1,2,6; @Employee,200,1,50,'';@Supervisor,200,1,50 ,'Cari Gutheil';@Filter,200,1,10,'complete'&# 34;
MyDb.dbDBType="SQL"
MyDb.dbDSN = "file name=" & udlPath & "GL_EOMIGT_GL_EOMAdmin.udl"
MyDb.dbUnit = 11305
MyDb.DbMode = "grid"
MyDb.dbNavigationIcon="std"
MyDb.dbGridInc = 10

MyDb.aspDBEP
set MyDb = Nothing
%>
</body>

</html>
08-17-2001, 05:26 PM
Leslie Taylor

using stored procedures error (reply)

I am in the process of purchasing a main contract right now.

Thanks

------------
Frank Kwong at 8/17/01 6:16:38 PM

wow.. ASPdbEP !! can you get a more updated copy ? USe the Designer and try to do the PUBS SP or ORacle's SP and see whethere you can get it to work. Checkout the examples also.

------------
Leslie Taylor at 8/17/01 5:16:50 PM

I have decided to try the stored procedure feature of ASPDB and I receive the following error. I have run the stored procedure through other means.

Thanks
Les

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/GLCloseChecklist/ChecklistSupervisorsp.asp, line 17

<html>

<head><title>Monthly JE Checklist by Supervisor</title></head>


<%

Set MyDb = Server.CreateObject("AspDB.EP")
MyDb.dbStoredProcCmdParams="usp_RetrieveJourna lEntries,4;@Year,3,1,4,2001;@Month,3,1,2,6; @Employee,200,1,50,'';@Supervisor,200,1,50 ,'Cari Gutheil';@Filter,200,1,10,'complete'&# 34;
MyDb.dbDBType="SQL"
MyDb.dbDSN = "file name=" & udlPath & "GL_EOMIGT_GL_EOMAdmin.udl"
MyDb.dbUnit = 11305
MyDb.DbMode = "grid"
MyDb.dbNavigationIcon="std"
MyDb.dbGridInc = 10

MyDb.aspDBEP
set MyDb = Nothing
%>
</body>

</html>
08-17-2001, 08:13 PM
Frank Kwong

using stored procedures error (reply)

even with the old versions it should still work. But it is easier to work with the new versions which corrected many bugs and also has many new features. Check the buy & Patches page inteh web site to see whether there is anything that would help you. But overall - it should work.

------------
Leslie Taylor at 8/17/01 6:26:31 PM

I am in the process of purchasing a main contract right now.

Thanks

------------
Frank Kwong at 8/17/01 6:16:38 PM

wow.. ASPdbEP !! can you get a more updated copy ? USe the Designer and try to do the PUBS SP or ORacle's SP and see whethere you can get it to work. Checkout the examples also.

------------
Leslie Taylor at 8/17/01 5:16:50 PM

I have decided to try the stored procedure feature of ASPDB and I receive the following error. I have run the stored procedure through other means.

Thanks
Les

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/GLCloseChecklist/ChecklistSupervisorsp.asp, line 17

<html>

<head><title>Monthly JE Checklist by Supervisor</title></head>


<%

Set MyDb = Server.CreateObject("AspDB.EP")
MyDb.dbStoredProcCmdParams="usp_RetrieveJourna lEntries,4;@Year,3,1,4,2001;@Month,3,1,2,6; @Employee,200,1,50,'';@Supervisor,200,1,50 ,'Cari Gutheil';@Filter,200,1,10,'complete'&# 34;
MyDb.dbDBType="SQL"
MyDb.dbDSN = "file name=" & udlPath & "GL_EOMIGT_GL_EOMAdmin.udl"
MyDb.dbUnit = 11305
MyDb.DbMode = "grid"
MyDb.dbNavigationIcon="std"
MyDb.dbGridInc = 10

MyDb.aspDBEP
set MyDb = Nothing
%>
</body>

</html>