Error while calling asp classic function from javascript

Question

I am trying to call classic ASP function from jQuery ajax but it is giving 404 error. I want to return records inJSON in this javascript code:

$.ajax({
    type: "POST",
    url: "../dbFile.asp/GetAllRecords",
    data: {"Id"="10"},
    error: function(XMLHttpRequest, textStatus, errorThrown){
        alert(textStatus);
    },
    success: function(result){
       alert("success");
    }
});
return false;
});

and my vb script function in asp classic file is

Function GetAllRecords()
    dim cmd, rs
    set cmd=Server.CreateObject("ADODB.Command")
    cmd.ActiveConnection = conn
    cmd.CommandType = 4
    cmd.CommandText = "GetAllRecords"
    set rs=Server.CreateObject("ADODB.Recordset")
    set rs=cmd.Execute()
    set GetAllRecords= rs
    set rs=nothing
    set cmd=nothing
End Function

Please guide, I am stuck here.

Comfortably Numb · Accepted Answer · 2013-09-02 23:23:39Z

4

You cannot call a classic ASP page as if you're calling ASP.NET WebMethod. You can call it by passing a parameter in Querystring, e.g.

url: "../dbFile.asp?Action=GetAllRecords",

And in your ASP code do something like

If Request("Action") = "GetAllRecords"
   Response.Write GetAllRecords()
   Response.End
End If

Note: For this to work your GetAllRecords() function need to return actual string with JSON or XML, right now it retruns a Recordset. You need to loop thru recordset, building string in the correct format.

answered Sep 2, 2013 at 23:23

Comfortably Numb

39.9k17 gold badges82 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

touseefkhan4pk Over a year ago

Thanks for your comprehensive answer. I managed to solve my problem by using aspjson liberary by calling asp page and returning data in form of json.

Collectives™ on Stack Overflow

Error while calling asp classic function from javascript

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related