Hi
I am developing a system locally which works fine. Locally i am using IIS 7.5.7600.16385.
When I upload the files to my remote server which is using IIS 7.0.6000.16386 the asp pages dont run the script and the output is just a blank white screen with no error messages!
The same page i go to locally runs the asp script.
I am using to access databases that are linked together.
Here is the script for the page:
Can anyone indicate where I have gone wrong please? Many thanks for your help!Code:<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% 'Dim cnnJudge 'Dim rsJudge 'Dim strSQL strSQL2 = "SELECT ID FROM Users WHERE Username = '"&Session("MM_Username")&"';" Set cnnJudge2 = Server.CreateObject("ADODB.Connection") cnnJudge2.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_private/pp.mdb")) Set rsJudge2 = cnnJudge2.Execute(strSQL2) Session("test") = rsJudge2("ID") strSQL = "SELECT [tbl-nominations].[nominee-first], [tbl-nominations].[nominee-last], [tbl-nominee-type].[nominee-type], [tbl-qualifications].[qualification-title] FROM [tbl-industry-sector] INNER JOIN ([tbl-qualifications] INNER JOIN ([tbl-nominee-type] INNER JOIN [tbl-nominations] ON [tbl-nominee-type].[type-id] = [tbl-nominations].[type-id]) ON [tbl-qualifications].[qualification-id] = [tbl-nominations].[qualification-id]) ON [tbl-industry-sector].[industry-id] = [tbl-qualifications].[industry-id] WHERE [tbl-nominations].[JUDGEID] = " & Session("test") & ";" Set cnnJudge = Server.CreateObject("ADODB.Connection") cnnJudge.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_private/pp.mdb")) Set rsJudge = cnnJudge.Execute(strSQL) %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>City & Guilds</title> <link href="css/styles.css" type="text/css" rel="stylesheet"/> </head> <body> <div id="container" > <img src="img/header.jpg"/> <div id="navigation"> <ul> <!--<li style="float:left; padding-left:7px;"><a href="#">home |</a></li>--> <li style="float:right"><a style="margin:0; padding-right:7px;" href="<%= MM_Logout %>">Logout</a></li> <!--<li style="float:left;"><a href="#">back |</a></li> <li style="float:left;"><a href="#">next |</a></li> <li style="float:right;"><a href="#">save & continue |</a></li>--> </ul> </div> <div id="text"> <h1>Judging home page</h1> <p>Welcome to the judging home page. On this page you can view our latest award news, review and score nominations and keep track of your work. </p> </div> <div id="news"> <h1>News</h1> <p>News items will appear here.</p> <p>26/10/2011 - User testing <br />15/11/2011 - Expected launch date</p> </div> <div id="data"> <!--<div class="candidate" style="color:#cc0000; text-align:left; font-weight:bold;">NAME</div> <div class="type" style="color:#cc0000; text-align:left; font-weight:bold;width:133px;">INDUSTRY</div> <div class="result" style="color:#cc0000; text-align:left; font-weight:bold;">TYPE</div> <div class="result" style="color:#cc0000; text-align:left; font-weight:bold;">OUTCOME</div>--> <table width="700" border="0" cellspacing="0" cellpadding="5" style="font-size:13px"> <tr style="color:#cc0000; font-weight:bold"> <td width="59">NAME</td> <td width="310">INDUSTRY</td> <td width="142">TYPE</td> <td width="102">OUTCOME</td> <td width="75">SCORE</td> </tr> <% Do While Not rsJudge.EOF %> <!--<div class="candidate" style="background-color:#f0ebeb; color:#000;"><a href="judge.2.1.asp?id=111111111111111111111111"><%=rsJudge("nominee-first")%> <%=rsJudge("nominee-last")%></a> </div> <div class="type" style="background-color:#f0ebeb; color:#000; width:200px; font-size:11px;">Advice, Guidance, Counselling and Mediation </div> <!--<div class="status" style="background-color:#f0ebeb; color:#000;">ss</div> <div class="result" style="background-color:#f0ebeb; color:#000;">Chief/Lead Verifier</div> <div class="type" style="background-color:#f0ebeb; color:#000;">Waiting to be judged</div>--> <a href="judge.2.1.asp?id=111111111111111111111111"><tr onmouseover="style.backgroundColor='#cc0000'; this.style.color='white'" onmouseout="style.backgroundColor='#ffF'; this.style.color='black'"> <td><%=rsJudge("nominee-first")%> <%=rsJudge("nominee-last")%></td> <td><%=rsJudge("qualification-title")%></td> <td><%=rsJudge("nominee-type")%></td> <td>Waiting to be judged</td> <td>10</td> </tr></a> <% rsJudge.MoveNext Loop %> </table> </div> <div id="reference"> <h1>Reference documents</h1> <p><a href="/docs/Guidelines for judges.doc" target="_blank">Full judging guidelines 2011 (Word document, 147KB)</a></p> <p><a href="/docs/Guidance notesV1.pdf" target="_blank">Guidance notes 2011 (PDF document, 226KB)</a></p> </div> <div id="help"> <h1>Help</h1> <!--<div style="margin:0 auto; width:298px; text-align:center; padding-top:20px;">--> <P>Training guide to follow </div> <!--<div id="nav"> <div id="back"><a href="<%= MM_Logout %>">Logout</a></div> <div id="next"><a href="judge.2.1.asp">Next</a></div> </div>--> </div> </body> </html> <% ' Clean Up rsJudge2.Close Set rsJudge2 = Nothing cnnJudge2.Close Set cnnJudge2 = Nothing rsJudge.Close Set rsJudge = Nothing cnnJudge.Close Set cnnJudge = Nothing %>
Reply With Quote
Bookmarks