trademark16
asked on
ASP page running on IIS7
I have a basic asp page the returns an xml content type from a sql database based on the sql statement that is passed into the page. My dev box is running IIS6 and everything works fine. On the production box, which is running IIS7 the page does not run. I have attached the code.
Additionally on the production box, asp and aspx have been enabled to run on IIS 7.
I have removed some spots on code with minimal success. I'm questioning the looping portion of the code at this time, but cannot narrow it down. The connection object is:
<%
Dim objConn
Dim sConn
Set objConn = Server.CreateObject("ADODB .Connectio n")
sConn = "DSN=" & Session.Value("DSN") & ";UID=" & Session.Value("DBUserID") & ";PWD=" & Session.Value("DBPassword" )
objConn.ConnectionString = sConn
objConn.Open
%>
Any help on what when wrong would be great. Tks.
Additionally on the production box, asp and aspx have been enabled to run on IIS 7.
I have removed some spots on code with minimal success. I'm questioning the looping portion of the code at this time, but cannot narrow it down. The connection object is:
<%
Dim objConn
Dim sConn
Set objConn = Server.CreateObject("ADODB
sConn = "DSN=" & Session.Value("DSN") & ";UID=" & Session.Value("DBUserID") & ";PWD=" & Session.Value("DBPassword"
objConn.ConnectionString = sConn
objConn.Open
%>
Any help on what when wrong would be great. Tks.
<!-- #include file="_connObj.asp" -->
<%
On Error Resume Next
response.ContentType="text/xml"
response.Write("<?xml version='1.0' encoding='ISO-8859-1'?>")
Dim sSQL
Dim rsResult
sSQL = Request.QueryString("sql")
Set rsResult = Server.CreateObject("ADODB.Recordset")
rsResult.Open sSQL, objConn
response.write("<records>")
If Not rsResult.eof Then
rsResult.MoveFirst
do While Not rsResult.Eof
response.write("<record>")
For each item In rsResult.fields
response.write("<" + item.name + ">")
response.Write(item.value)
response.write("</" + item.name + ">")
Next
response.write("</record>")
rsResult.MoveNext
Loop
End If
rsResult.close
objConn.close
Set rsResult = Nothing
Set ObjConn = Nothing
response.write("</records>")
%>
Are you receiving any errors?
Have you enabled ASP pages in IIS? By default IIS7 does not server 'Classic' ASP pages.
Nice Catch CCongdon!
I haven't had the need to use Classic on IIS7, but that's a great thing to note.
I haven't had the need to use Classic on IIS7, but that's a great thing to note.
ASKER
I have enabled asp in IIS as i mentioned in the second paragraph of my question:
"Additionally on the production box, asp and aspx have been enabled to run on IIS 7."
"Additionally on the production box, asp and aspx have been enabled to run on IIS 7."
ASKER
With regards to errors, i get the following on the page:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Only one top level element is allowed in an XML document. Error processing resource 'http://ssssql02/select.asp?sql=select%...
<record></record><record>< /record><r ecord></re cord><reco rd></recor d><reco...
It's as if it doe not write the <records> tag first, nor any data. Below is that the file looks like on IIS 6:
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <records>
- <record>
<actcd>L</actcd>
<activity>Low</activity>
<ordinal>1</ordinal>
</record>
- <record>
<actcd>LM</actcd>
<activity>Low to Moderate</activity>
<ordinal>2</ordinal>
</record>
- <record>
<actcd>M</actcd>
<activity>Moderate</activi ty>
<ordinal>3</ordinal>
</record>
- <record>
<actcd>MH</actcd>
<activity>Moderate to High</activity>
<ordinal>4</ordinal>
</record>
- <record>
<actcd>NI</actcd>
<activity>Not Investigated</activity>
<ordinal>0</ordinal>
</record>
- <record>
<actcd>VH</actcd>
<activity>Very High</activity>
<ordinal>5</ordinal>
</record>
</records>
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------
Only one top level element is allowed in an XML document. Error processing resource 'http://ssssql02/select.asp?sql=select%...
<record></record><record><
It's as if it doe not write the <records> tag first, nor any data. Below is that the file looks like on IIS 6:
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <records>
- <record>
<actcd>L</actcd>
<activity>Low</activity>
<ordinal>1</ordinal>
</record>
- <record>
<actcd>LM</actcd>
<activity>Low to Moderate</activity>
<ordinal>2</ordinal>
</record>
- <record>
<actcd>M</actcd>
<activity>Moderate</activi
<ordinal>3</ordinal>
</record>
- <record>
<actcd>MH</actcd>
<activity>Moderate to High</activity>
<ordinal>4</ordinal>
</record>
- <record>
<actcd>NI</actcd>
<activity>Not Investigated</activity>
<ordinal>0</ordinal>
</record>
- <record>
<actcd>VH</actcd>
<activity>Very High</activity>
<ordinal>5</ordinal>
</record>
</records>
Hello trademark16
Give this a shot on the system that will not run your code
http://ee.cffcs.com/Q_24386646/Q_24386646.asp
code
http://ee.cffcs.com/Q_24386646/Q_24386646.zip
If this works on both machines then there is an issue with you code running on IIS7
Good Luck
Carrzkiss
Give this a shot on the system that will not run your code
http://ee.cffcs.com/Q_24386646/Q_24386646.asp
code
http://ee.cffcs.com/Q_24386646/Q_24386646.zip
If this works on both machines then there is an issue with you code running on IIS7
Good Luck
Carrzkiss
ASKER
It worked on IIS6 but i received the following error on IIS 7:
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
Do you think it is an installation issue?
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
Do you think it is an installation issue?
On the IIS7 machine, do you have Show Friendly URL enabled?
Internet Explorer
Tools | Internet Options | Advanced |
[ ] Show Friendly HTTP Error Messages (Uncheck)
Then reload the page and see what error you recieve?
Internet Explorer
Tools | Internet Options | Advanced |
[ ] Show Friendly HTTP Error Messages (Uncheck)
Then reload the page and see what error you recieve?
ASKER
I now get:
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Invalid at the top level of the document. Error processing resource 'http://192.168.16.4/Q_24386646.asp'. Line 1, Position...
<?xml version="1.0" encoding="ISO-8859-1"?>An error occurred on the server when processing the URL. Please contact the...
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------
Invalid at the top level of the document. Error processing resource 'http://192.168.16.4/Q_24386646.asp'. Line 1, Position...
<?xml version="1.0" encoding="ISO-8859-1"?>An error occurred on the server when processing the URL. Please contact the...
I found this, give it a try on the IIS7 system
(Internet Explorer)
Internet options -> Security, [Custom Levels]
"access data sources across domains". Its usually
disabled. [Enable] it. and the refresh the page.
Still doing research on it...
(Internet Explorer)
Internet options -> Security, [Custom Levels]
"access data sources across domains". Its usually
disabled. [Enable] it. and the refresh the page.
Still doing research on it...
ASKER
Still no luck. If it helps the browser i am using is local to the web server running on the windows 2008 server.
Can you view the link that I have up on the IIS7 system?
http://ee.cffcs.com/Q_24386646/Q_24386646.asp
This will determin if it is the Browser.
If you can view this, then there is an Internal Issue on the system and rules out the browser.
http://ee.cffcs.com/Q_24386646/Q_24386646.asp
This will determin if it is the Browser.
If you can view this, then there is an Internal Issue on the system and rules out the browser.
ASKER
Yes, i can view your link just fine.
OK.
Since you can view the external link, then your Browser is not the issue.
There is an enternal issue with IIS7.
Just found this information, maybe this will help you to get up and running with XML on your system.
http://andrew.thomas.net.nz/blog/post/2009/03/09/Setting-up-IIS-7-to-handle-sitmapxml-request-in-code.aspx
IIS7 does things a lot different then previous version's of IIS.
(I am use to IIS4 and IIS5 myself)
Let me know if the link helps.
Carrzkiss
Since you can view the external link, then your Browser is not the issue.
There is an enternal issue with IIS7.
Just found this information, maybe this will help you to get up and running with XML on your system.
http://andrew.thomas.net.nz/blog/post/2009/03/09/Setting-up-IIS-7-to-handle-sitmapxml-request-in-code.aspx
IIS7 does things a lot different then previous version's of IIS.
(I am use to IIS4 and IIS5 myself)
Let me know if the link helps.
Carrzkiss
ASKER
Unfortunately this didn't help either however, i did get a different error:
Server Error in '/' Application.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
The DefaultHttpHandler.BeginPr ocessReque st method is not supported by IIS integrated pipeline mode.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.PlatformNotSupporte dException : The DefaultHttpHandler.BeginPr ocessReque st method is not supported by IIS integrated pipeline mode.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[PlatformNotSupportedExcep tion: The DefaultHttpHandler.BeginPr ocessReque st method is not supported by IIS integrated pipeline mode.]
System.Web.DefaultHttpHand ler.BeginP rocessRequ est(HttpCo ntext context, AsyncCallback callback, Object state) +654
System.Web.CallHandlerExec utionStep. System.Web .HttpAppli cation.IEx ecutionSte p.Execute( ) +398
System.Web.HttpApplication .ExecuteSt ep(IExecut ionStep step, Boolean& completedSynchronously) +274
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074
Server Error in '/' Application.
--------------------------
The DefaultHttpHandler.BeginPr
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.PlatformNotSupporte
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[PlatformNotSupportedExcep
System.Web.DefaultHttpHand
System.Web.CallHandlerExec
System.Web.HttpApplication
--------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074
Not familuar with that error unfortunantly.
If you did what was on the link, then un-do-it.
So we can get back to the issue at hand, without having to troubleshoot something that was
Caused by something else.
Can you run a plain .xml file from the server?
If you did what was on the link, then un-do-it.
So we can get back to the issue at hand, without having to troubleshoot something that was
Caused by something else.
Can you run a plain .xml file from the server?
<?xml version="1.0" encoding="ISO-8859-1"?>
<records>
<record>
<actdc>L</actdc>
<activity>Low</activity>
<ordinal>1</ordinal>
</record>
<record>
<actdc>LM</actdc>
<activity>Low to Moderate</activity>
<ordinal>2</ordinal>
</record>
<record>
<actdc>M</actdc>
<activity>Moderate</activity>
<ordinal>3</ordinal>
</record>
<record>
<actdc>MH</actdc>
<activity>Moderate to High</activity>
<ordinal>4</ordinal>
</record>
<record>
<actdc>NI</actdc>
<activity>Not Investigated</activity>
<ordinal>0</ordinal>
</record>
<record>
<actdc>VH</actdc>
<activity>Very High</activity>
<ordinal>6</ordinal>
</record>
</records>
Another link for you.
http://forums.iis.net/t/1050120.aspx
This is about the MIME File Types within IIS7.
Please have a look at the first post, and then the last post's link.
Good Luck
Carrzkiss
http://forums.iis.net/t/1050120.aspx
This is about the MIME File Types within IIS7.
Please have a look at the first post, and then the last post's link.
Good Luck
Carrzkiss
Try this please.
Within IIS7 Manager.
Right click on the page and choose [Browse]
See if the page comes up?
IF it does then check to make sure that you are typing out the url page name correctly?
As in.
Example:
Name of page = MySite.asp
you typed out: = mysite.asp
I am not sure if this is your case, but just something to try.
Let me know?
Carrzkiss
Within IIS7 Manager.
Right click on the page and choose [Browse]
See if the page comes up?
IF it does then check to make sure that you are typing out the url page name correctly?
As in.
Example:
Name of page = MySite.asp
you typed out: = mysite.asp
I am not sure if this is your case, but just something to try.
Let me know?
Carrzkiss
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I removed the handler maapings, then per the one article change the content type from text/xml to applicaiton/xml with no luck. Verified the case on the file name, all were lower so that was also not the issue. I also changed a config setting per the article and again with no luck.
After that i removed teh on erro resume line of code and changes and the IIS setting "send errors to brower" to true and now i get this:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
A string literal was expected, but no opening quote character was found. Error processing resource 'http://ssssql02/select....
<?xml version='1.0' encoding='ISO-8859-1'?> <font face="Arial" size=2>
-------------------------- ---------- ----...
After that i removed teh on erro resume line of code and changes and the IIS setting "send errors to brower" to true and now i get this:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------
A string literal was expected, but no opening quote character was found. Error processing resource 'http://ssssql02/select....
<?xml version='1.0' encoding='ISO-8859-1'?> <font face="Arial" size=2>
--------------------------
Try this.
Maybe it is picking up on some code that is not suppose to be there?
Let me know
Carrzkiss
Maybe it is picking up on some code that is not suppose to be there?
Let me know
Carrzkiss
<% Response.ContentType="application/xml" %><?xml version="1.0" encoding="ISO-8859-1"?><%
Set cnxml = Server.CreateObject("ADODB.Connection")
cnxml.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath ("Q_24386646.mdb") & ";"
cnxml.Open
sqlxml = "SELECT ID, actcd, activity, ordinal FROM Table1"
Set rsxml = Server.CreateObject("ADODB.Recordset")
rsxml.Open sqlxml, cnxml
%><records>
<%DO Until (rsxml.EOF)%>
<record>
<actdc><%=rsxml("actcd")%></actdc>
<activity><%=rsxml("activity")%></activity>
<ordinal><%=rsxml("ordinal")%></ordinal>
</record><%
rsxml.MoveNext
Loop
rsxml.close
Set rsxml = nothing
%></records>
ASKER
I get the same following error:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
A string literal was expected, but no opening quote character was found. Error processing resource 'http://ssssql02/newtest...
<?xml version="1.0" encoding="ISO-8859-1"?> <font face="Arial" size=2>
-------------------------- ---------- ----...
Which the more i read people claim the error is at size=2 should be size="2", which is a default somewhere when IIS spits out the error. Not helpful to us.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------
A string literal was expected, but no opening quote character was found. Error processing resource 'http://ssssql02/newtest...
<?xml version="1.0" encoding="ISO-8859-1"?> <font face="Arial" size=2>
--------------------------
Which the more i read people claim the error is at size=2 should be size="2", which is a default somewhere when IIS spits out the error. Not helpful to us.
try this one.
Carrzkiss
Carrzkiss
<% Response.ContentType="application/xml" %><?xml version="1.0" encoding="ISO-8859-1"?><%
Set cnxml = Server.CreateObject("ADODB.Connection")
cnxml.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath ("Q_24386646.mdb") & ";"
cnxml.Open
sqlxml = "SELECT ID, actcd, activity, ordinal FROM Table1"
Set rsxml = Server.CreateObject("ADODB.Recordset")
rsxml.Open sqlxml, cnxml
%><records>
<%DO Until (rsxml.EOF)%>
<record>
<actdc><%=rsxml("actcd")%></actdc>
<activity><%=rsxml("activity")%></activity>
<ordinal><%=Clng(rsxml("ordinal"))%></ordinal>
</record><%
rsxml.MoveNext
Loop
rsxml.close
Set rsxml = nothing
%></records>
ASKER
Same error. What was the difference in the two files? I must have missed it.
first file
<ordinal><%=rsxml("ordinal ")%></ordi nal>
2nd file
<ordinal><%=Clng(rsxml("or dinal"))%> </ordinal>
I am running out of idea's?
<ordinal><%=rsxml("ordinal
2nd file
<ordinal><%=Clng(rsxml("or
I am running out of idea's?
ASKER
Same here. I was trying the recordset with a command object instead with no luck. I went that direction becasue when i comment out the line of code:
rsResult.Open sSQL, objConn
I then get an XML file. With no data of course, but the xml file is a least produced.
rsResult.Open sSQL, objConn
I then get an XML file. With no data of course, but the xml file is a least produced.
ASKER
Removed everything related to xml and just tried to produce an html page with the following code and this failed as well on IIS7, but worked on IIS6:
<!-- #include file="_connObj.asp" -->
<%
On Error Resume Next
response.ContentType="text /html"
Dim sSQL, sWhere
Dim rsResult
sSQL = Request.QueryString("sql")
Set rsResult = Server.CreateObject("ADODB .Recordset ")
rsResult.Open sSQL, objConn
If Not rsResult.eof Then
rsResult.MoveFirst
do While Not rsResult.Eof
For each item In rsResult.fields
response.write(item.name + "<br>")
response.Write(item.value + "<br>")
Next
rsResult.MoveNext
Loop
End If
rsResult.close
objConn.close
Set rsResult = Nothing
Set ObjConn = Nothing
%>
<!-- #include file="_connObj.asp" -->
<%
On Error Resume Next
response.ContentType="text
Dim sSQL, sWhere
Dim rsResult
sSQL = Request.QueryString("sql")
Set rsResult = Server.CreateObject("ADODB
rsResult.Open sSQL, objConn
If Not rsResult.eof Then
rsResult.MoveFirst
do While Not rsResult.Eof
For each item In rsResult.fields
response.write(item.name + "<br>")
response.Write(item.value + "<br>")
Next
rsResult.MoveNext
Loop
End If
rsResult.close
objConn.close
Set rsResult = Nothing
Set ObjConn = Nothing
%>
can you create a page and call it
Add this line to it.
<%response.write("Hello World")%>
Name the page hello.asp
Run the script...
http://localhost/hello.asp
And let me know what you see?
Add this line to it.
<%response.write("Hello World")%>
Name the page hello.asp
Run the script...
http://localhost/hello.asp
And let me know what you see?
ASKER
I see Hello World.
ASKER
Going to rewrite in ASP.net.
Thanks for all your help.
Thanks for all your help.
Good luck with the new coding.
Carrzkiss
Carrzkiss