Results 1 to 4 of 4

Thread: using stored procedures error

  1. 08-17-2001, 04:16 PM #1
    Leslie Taylor Guest

    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>

    <!-- #include VIRTUAL=&#39;/IGTInclude/udlInclude.inc&#39; -->
    <%

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

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

    </html>
    Reply With Quote Reply With Quote
  2. 08-17-2001, 05:16 PM #2
    Frank Kwong Guest

    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&#39;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 &#39;800a0e78&#39;

    Operation is not allowed when the object is closed.

    /GLCloseChecklist/ChecklistSupervisorsp.asp, line 17


    <html>

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

    <!-- #include VIRTUAL=&#39;/IGTInclude/udlInclude.inc&#39; -->
    <%

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

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

    </html>
    Reply With Quote Reply With Quote
  3. 08-17-2001, 05:26 PM #3
    Leslie Taylor Guest

    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&#39;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 &#39;800a0e78&#39;

    Operation is not allowed when the object is closed.

    /GLCloseChecklist/ChecklistSupervisorsp.asp, line 17


    <html>

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

    <!-- #include VIRTUAL=&#39;/IGTInclude/udlInclude.inc&#39; -->
    <%

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

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

    </html>
    Reply With Quote Reply With Quote
  4. 08-17-2001, 08:13 PM #4
    Frank Kwong Guest

    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&#39;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 &#39;800a0e78&#39;

    Operation is not allowed when the object is closed.

    /GLCloseChecklist/ChecklistSupervisorsp.asp, line 17


    <html>

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

    <!-- #include VIRTUAL=&#39;/IGTInclude/udlInclude.inc&#39; -->
    <%

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

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

    </html>
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules