Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: help a non-ASP programmer with debugging ASP program

    Setup: No experience with ASP, IIS V5 (I think. I can not tell.), Windows 2000, If you need more info please ask.

    I am tying to update an Oracle data base by calling a stored procedure from a web page. Everything appears to run smoothly except no data is ever inserted.

    I need help debugging what might be going wrong.

    Here is the source:
    Code:
    <%@ Language=VBScript %>
    
    <!-- 
    include alert.asp
    -->
    
    <%
    response.buffer = TRUE
    response.expires = TRUE
    
    On Error Resume Next
    
    dim queryStr 
    queryStr = request.QueryString("action")&request.form
    
        Set Comm = Server.CreateObject("ADODB.Command")
    Comm.connectiontimeout = 60
        comm.ActiveConnection = "dsn=telus2_iasdb;uid=reports;pwd=reports;"
        comm.commandtype=4   
    
        comm.commandtext = "log_hits"
    
        set param = comm.createparameter("InPut",200,1,500,querystr)
    '    set param = comm.Parameters
    '    param.append comm.createparameter(querystr,200,1)
    
    comm.parameters.append param
    
        'Pass the input value
    '    comm("InPut") = querystr
    
        comm.execute()
    
    response.redirect(querystr)
    
    %>
    I do not get any error messages. The IIS server logs show that the request for log_hits() is received. (See below). But my function never gets executed. Can some one tell me how I can check the reponse code from comm.execute. If any one sees anything else do not be bashful.

    Thanks.

    Log output
    2004-12-15 22:02:35 10.89.44.97 - 10.26.70.244 80 POST /hits/log.asp action=http://frasier:88/ows-bin/rwcgi60.exe? 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+T312461 ;+.NET+CLR+1.1.4322)
    2004-12-15 22:03:19 10.89.44.97 - 10.26.70.244 80 POST /hits/log.asp action=http://frasier:88/ows-bin/rwcgi60.exe? 200 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+T312461 ;+.NET+CLR+1.1.4322)
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Additional info: I have successfully tested the DSN connection. I have successfully inserted a record into Oracle when I call the stored procedure via methods other than ASP
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    More additional info: This script is working when talking to a different data base running on Oracle 8. The other script is also running in a different IIS instance. I am trying to talk with Oracle 9i now. Is anyone aware of some configuration setting that could affect this? I am not conversant with IIS either.
    Last edited by Todd Barkus; 12-16-04 at 14:39.
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    First thing I'd do is comment out your

    on error resume next

    Then you can see what is actually happening
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  5. #5
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Thanks for the tip. I actually found out how to print the errors from a post on a different forum. At that point I was able to figure out my issues.

    An odd thing is that without "on error resume next" statement the ASP will fail with a "method not found" error. With the "on error resume next" statement it does what it is supposed to.
    NOTE: Please disregard the label "Senior Member".

  6. #6
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    would I be right in guessing that it is failing at this line...
    Code:
    queryStr = request.QueryString("action")&request.form

Posting Permissions

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