AJAX Code nightmare

cyberwit · 29-10-2007 8:21pm #1

Could someone please tell me why the following ajax is not working. I have it running on my IIS on my PC:

Html page:

<html>
<head>
<script src="selectcustomer.js"></script>
</head>

<body>

<form>
Select a Customer:
<select name="customers" onchange="showCustomer(this.value)">
<option value="ALFKI">Alfreds Futterkiste
<option value="NORTS ">North/South
<option value="WOLZA">Wolski Zajazd
</select>
</form>

<p>
<div id="txtHint"><b>Customer info will be listed here.</b></div>
</p>

</body>
</html>

ASP Page

<%
response.expires=-1
sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="
sql=sql & "'" & request.querystring("q") & "'"

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql, conn

response.write("<table>")
do until rs.EOF
for each x in rs.Fields
response.write("<tr><td><b>" & x.name & "</b></td>")
response.write("<td>" & x.value & "</td></tr>")
next
rs.MoveNext
loop

response.write("</table>")
%>

Javascript

var xmlHttp

function showCustomer(str)
{
xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
{
alert ("Your browser does not support AJAX!");
return;
}
var url="getcustomer.asp";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET","getcustomer.asp",true);
xmlHttp.send(null);
}

function stateChanged()
{
if (xmlHttp.readyState==4)
{
document.getElementById("txtHint").innerHTML=xmlHttp.responseText;
}
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}

Ginger · 29-10-2007 8:45pm

Download fiddler and check to see if the AJAX is firing or not.

Also add the following code to your javascript

if (xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlHttp.responseText;

    }
  else
    {
    alert("Problem retrieving XML data"),
    }

Ginger · 29-10-2007 8:45pm

Also can you check if you can run the ASP file and if its working correctly, it may be returning incorrect information

cyberwit · 29-10-2007 9:12pm

Microsoft Script Debugger is telling me that "a Runtime Error has occurred do i wish to debug? Line: 15 Error: Access denied
Line 15 selectcustomer.js : xmlHttp.open("GET","getcustomer.asp",true);

Firefox shows me the following (my asp code):

<% response.expires=-1 sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID=" sql=sql & "'" & request.querystring("q") & "'" set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("db/northwind.mdb")) set rs = Server.CreateObject("ADODB.recordset") rs.Open sql, conn response.write("
") do until rs.EOF for each x in rs.Fields response.write("" & x.name & "") response.write(" " & x.value & "
") next rs.MoveNext loop response.write("
") %>

Ginger · 29-10-2007 9:28pm

Right

Run the ASP file with a parameter q .. verify that in fact it returns information..

Is the DB open and also have you given full permissions on the folder in windows to the IUSR account?

cyberwit · 30-10-2007 12:56am

Ginger wrote: »

Right

Run the ASP file with a parameter q .. verify that in fact it returns information..

Is the DB open and also have you given full permissions on the folder in windows to the IUSR account?

I tested the asp page with
response.write("Hello World!") and it works.

I am not sure what you are taking about with regards the IUSER Account, dont i need to setup the database up in such a way as to be able to access it using the web or visual basic or ASP i just cant remember

Ginger · 30-10-2007 5:39am

No no:.. thats not what I asked.. I asked you to test your current page and pass in a correct value for q so that it will return the table... Access is notorious when doing web programming for locking and returning errors it should never be used.. use MSSQL 2005 Express edition if you can!

ron_darrell · 30-10-2007 12:30pm

customer id is a number not text so do not encapsulate in quotes - check your sql statement

-RD

Ginger · 30-10-2007 12:33pm

Unless customer ID is a string

cyberwit · 30-10-2007 4:52pm

I am just using Access in this test example i would use oracle in the finished product. The example i am runnning is the one on the W3C school website

Ginger · 30-10-2007 5:13pm

Again can you do something like this

http://yoursite/page.asp?q=1

I want to see if its returning a table or not..

cyberwit · 30-10-2007 5:34pm

Ginger wrote: »

Again can you do something like this

http://yoursite/page.asp?q=1

I want to see if its returning a table or not..

Sorry i taught i had already said it does not return a table only the asp code

cyberwit · 30-10-2007 5:37pm

I am not using visual webdeveloper or dreamweaver just notepad my priority is gettin the ajax working not really concerned with design issues

Ginger · 30-10-2007 5:50pm

Ok, if its returning ASP, then your ASP is incorrect and has an error...

What version of Windows are you using?

Ginger · 30-10-2007 5:59pm

Actually is it returning the ASP code unexecuted as text or something or am I misreading that

mewso · 30-10-2007 6:40pm

You are building your url with querystring then not using it:-

var url="getcustomer.asp";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET","getcustomer.asp",true);
xmlHttp.send(null);

change to

xmlHttp.open("GET",url,true);

Also your first line in the asp file should probably set the contentype:-

response.contentype = "text/plain"

Ginger · 30-10-2007 6:55pm

Give that man a biscuit! Good eyes

cyberwit · 30-10-2007 7:38pm

xmlHttp.open("GET",url,true);

I had that originally but did not work neither does the new way either.

Yes all the ASP file is showing is ASP code unexecuted as text

Ginger · 30-10-2007 7:47pm

what version of windows then... Sounds like ASP.DLL aint working or the .ASP MIME type is being parsed as text

cyberwit · 30-10-2007 7:53pm

Windows XP Professional. I installed the IIS on my computer and it runs previous websites i have produced more or less originally when i tryed to use it i was asked for a username and passwork but found out how to use it.

Ginger · 30-10-2007 7:55pm

Can you create a page called test.asp and put the following in

<%=Now()%>

that should just show the current time.

If it doesnt then we just need to sort out the ASP stuff for you

cyberwit · 30-10-2007 8:09pm

Nope not working again just showing asp code <%=Now()%>

I have used the IIS server in my college fine its just this one installed on my pc is driving me mad

Ginger · 30-10-2007 8:17pm

Is ASP installed I wonder...

It should work by default. By any chance do you have Norton AV installed or something that could be knocking it out.

Can you do the following

Open the IIS manager

Select Default Web Site and bring up the Properties dialog box.

Select the HTTP Headers tab.

Under MIME Map, click the File Types tab

Check if ASP is there and if it is, is all verbs going through ASP.dll???

Ginger · 30-10-2007 8:28pm

Also check the following in your event viewer

MSDTC errors (4427,4691,4135 are common error events for this)
W3SVC Event 36 "The server failed to load application '/LM/W3SVC/1/ROOT/'. The error was 'Class not registered"

Also need to you to turn off friendly error messages in IE

Also have a look at the following

http://support.microsoft.com/default.aspx?scid=kb;en-us;309051#2

cyberwit · 30-10-2007 8:34pm

Ginger wrote: »

Is ASP installed I wonder...

It should work by default. By any chance do you have Norton AV installed or something that could be knocking it out.

Can you do the following

Open the IIS manager

Select Default Web Site and bring up the Properties dialog box.

Select the HTTP Headers tab.

Under MIME Map, click the File Types tab

Check if ASP is there and if it is, is all verbs going through ASP.dll???

Thre is no registered file types it's empty

Ginger · 30-10-2007 8:36pm

Could be in there somewhere.. sorry mate I doing this from memory, i dont have IIS installed on this PC

cyberwit · 30-10-2007 8:48pm

Don't worry about it i am just greatful for the help

Ginger · 30-10-2007 8:53pm

Please also have a look at this http://brooksyounce.tripod.com/XpAspFix.htm

cyberwit · 30-10-2007 8:54pm

Can i use anything else instead of IIS now i dont want to install a seperate server just some application maybe that will enable me to run the site

Ginger · 30-10-2007 8:55pm

IIS natively runs ASP, just something weird with your installation

mewso · 30-10-2007 11:33pm

Ginger wrote: »

Could be in there somewhere.. sorry mate I doing this from memory, i dont have IIS installed on this PC

Just checked there - Home Directory tab - click configuration and you will see a list of file extensions. .asp should be linked to asp.dll.

cyberwit · 31-10-2007 12:02am

musician wrote: »

Just checked there - Home Directory tab - click configuration and you will see a list of file extensions. .asp should be linked to asp.dll.

The asp.dll file is there

sicruise · 31-10-2007 12:26am

Lads... this just sounds like a permissions issue...

Ginger · 31-10-2007 5:37am

Nah permissions would give a 403 error or similar types of errors not show the ASP code in the browser..

Ginger · 31-10-2007 6:58am

1. Do you have Anti virus software running (with script blocking or something similar)
2. Is ASP.DLL registered
3. Is it being used for all verbs for the ASP file types

Did you check out those links i posted earlier

FindingNemo · 31-10-2007 12:01pm

have you checked your .net configuration. go into admin tools, .net configuration, list the assemblies and make sure AJAX is registered ?

Ginger · 31-10-2007 12:02pm

Its classic ASP not .NET

amen · 31-10-2007 1:38pm

back up a bit
try http://yourcomputername

if IIS is installed correctly the you will get a "Welcome to IIS" page.

if you don't get this reinstall IIS.

If you do get this create a simple page with the code below call it test.asp
and see can you navigate to the page. If you can you should see hello in the middle of page. At this point you know IIS is working and ASP pages are processed correctly.

[PHP]<%
Response.Write ("HELLO")
%>
[/PHP]

next step is to test you asp page
so navigate it to passing in any parameters
and see what happends
if it works great you have a problem calling it from JScript
if it doesn;t you should get an error

post the error here

mewso · 31-10-2007 3:40pm

I think we've been through all that. It does not seem to be parsing the asp script. Read above and you will see this. A re-install of iis might be in order.

cyberwit · 31-10-2007 9:18pm

I reinstalled IIS and remove security related functions in the Directory Security because i could not run iisstart.asp because it was asking me for a password and username now it does not it produces an error page - The page cannot be displayed HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Looked at the resolution to the problem on microsoft website confused same error message when i try to run my test website asp not, a html webpage is showing fine

cyberwit · 31-10-2007 9:19pm

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

Please try the following:

Click the Refresh button, or try again later.

Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'GetObject'
/localstart.asp, line 40

Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30)

Page:
GET /localstart.asp

Time:
Wednesday, October 31, 2007, 9:14:00 PM

More information:
Microsoft Support

FindingNemo · 02-11-2007 1:34pm

http://support.microsoft.com/default.aspx/kb/251361

cyberwit · 06-11-2007 7:11pm

I ran the site on the IIS server in college a works perfectly I want to thank all those of you for your very much appreciated assistance.

AJAX Code nightmare

Comments