I am developing an app on xp and porting it over to our server. Its an
ASP web app (not ASP.NET) with an SQL Server 2000 backend and it seems
to work great on the development machine. When I move it over to the
server though I lose all data in my comboboxes. The page loads
correctly with all backgrounds and images, but the comboboxes are
empty. Both database environments are identical but the only issue is
different versions of iis. Wold that cause this issue? I dont think
its a connection issue since I think I would be getting an error if
the site were not able to talk to the DSN.
Any help would be appreciated.
Thanks
Re: Port from iis 5.1 (xp) to iis 6.0 (server 2003)
am 29.08.2007 17:50:36 von Daniel Crichton
sd_eds wrote on Wed, 29 Aug 2007 08:40:44 -0700:
> I am developing an app on xp and porting it over to our server. Its an
> ASP web app (not ASP.NET) with an SQL Server 2000 backend and it seems
> to work great on the development machine. When I move it over to the
> server though I lose all data in my comboboxes. The page loads
> correctly with all backgrounds and images, but the comboboxes are
> empty. Both database environments are identical but the only issue is
> different versions of iis. Wold that cause this issue? I dont think its
> a connection issue since I think I would be getting an error if the
> site were not able to talk to the DSN.
> Any help would be appreciated.
> Thanks
Check your code for On Error Resume Next - if that's present you'll never
see any error messages, your page will execute to the end quietly and is
often the cause for data generated by ASP to be "missing".
Trying viewing the source HTML in your browser - if you can see ASP code
then your ASP pages are not being processed by the ASP handler in IIS. If
you're sure that you're requesting the files as http://servername/page.asp
then seeing ASP code in the source would suggest that someone has mapped the
..asp extension in IIS to another DLL which isn't processing the ASP.
The only other thing I can think of is that the DSN is pointing to a
different SQL server which has empty tables, and the reason the combo boxes
are empty is because no data is being returned.
Some sample code from the problem page might also help shed light on the
issue.
Dan
Re: Port from iis 5.1 (xp) to iis 6.0 (server 2003)
am 29.08.2007 18:35:04 von sd_eds
> Check your code for On Error Resume Next - if that's present you'll never
> see any error messages, your page will execute to the end quietly and is
> often the cause for data generated by ASP to be "missing".
>
> Trying viewing the source HTML in your browser - if you can see ASP code
> then your ASP pages are not being processed by the ASP handler in IIS. If
> you're sure that you're requesting the files ashttp://servername/page.asp
> then seeing ASP code in the source would suggest that someone has mapped the
> .asp extension in IIS to another DLL which isn't processing the ASP.
>
> The only other thing I can think of is that the DSN is pointing to a
> different SQL server which has empty tables, and the reason the combo boxes
> are empty is because no data is being returned.
>
> Some sample code from the problem page might also help shed light on the
> issue.
>
> Dan
I commented out the ON ERROR line and the same behavior is occuring.
Nope, the code is not showing. I can see all the JS functions but not
the ASP code.
I have checked the DSN and it looks good to me. I went in to
enterprise manager and checked the tables that are being accessed and
there is data there.
Here are some code snippets. Let me know if I should add more.
>From conn.inc:
<%
dim con
set con = server.createobject("ADODB.Connection")
con.ConnectionString = "Data Source=scheduler;"
%>
>From the asp page:
<%
if con.STATE = adStateClosed then
con.Open
end if
dim rs, sql, rso, sqlo, office_id
sqlo = "SELECT office_id, city, name FROM office ORDER BY city"
set rso = Server.CreateObject("ADODB.Recordset")
rso.ActiveConnection = con
rso.Source=sqlo
rso.CursorType=adOpenStatic
rso.Open
IF NOT rso.BOF AND NOT rso.EOF THEN
office_id = rso("office_id")
DO WHILE NOT rso.EOF
IF request("office_id") = cStr(rso("office_id")) then
%>
<%
else
%>
<%
end if
rso.MOVENEXT
LOOP
set rso = nothing
END IF
%>
Re: Port from iis 5.1 (xp) to iis 6.0 (server 2003)
am 29.08.2007 20:22:01 von theedwards
On Aug 29, 12:35 pm, sd_eds wrote:
> > Check your code for On Error Resume Next - if that's present you'll never
> > see any error messages, your page will execute to the end quietly and is
> > often the cause for data generated by ASP to be "missing".
>
> > Trying viewing the source HTML in your browser - if you can see ASP code
> > then your ASP pages are not being processed by the ASP handler in IIS. If
> > you're sure that you're requesting the files ashttp://servername/page.asp
> > then seeing ASP code in the source would suggest that someone has mapped the
> > .asp extension in IIS to another DLL which isn't processing the ASP.
>
> > The only other thing I can think of is that the DSN is pointing to a
> > different SQL server which has empty tables, and the reason the combo boxes
> > are empty is because no data is being returned.
>
> > Some sample code from the problem page might also help shed light on the
> > issue.
>
> > Dan
>
> I commented out the ON ERROR line and the same behavior is occuring.
>
> Nope, the code is not showing. I can see all the JS functions but not
> the ASP code.
>
> I have checked the DSN and it looks good to me. I went in to
> enterprise manager and checked the tables that are being accessed and
> there is data there.
>
> Here are some code snippets. Let me know if I should add more.
>
> >From conn.inc:
>
> <%
> dim con
> set con = server.createobject("ADODB.Connection")
> con.ConnectionString = "Data Source=scheduler;"
> %>
>
> >From the asp page:
>
> <%
> if con.STATE = adStateClosed then
> con.Open
> end if
>
> dim rs, sql, rso, sqlo, office_id
>
> sqlo = "SELECT office_id, city, name FROM office ORDER BY city"
> set rso = Server.CreateObject("ADODB.Recordset")
> rso.ActiveConnection = con
> rso.Source=sqlo
> rso.CursorType=adOpenStatic
> rso.Open
>
> IF NOT rso.BOF AND NOT rso.EOF THEN
> office_id = rso("office_id")
>
> DO WHILE NOT rso.EOF
> IF request("office_id") = cStr(rso("office_id")) then
> %>
>
> <%
> else
> %>
>
> <%
> end if
>
> rso.MOVENEXT
> LOOP
>
> set rso = nothing
> END IF
>
> %>- Hide quoted text -
>
> - Show quoted text -
Got it. I did not give proper permission to IUSR account on the
machine.