Sql Server generated Web Links result in "Page cannot be found"

Reply

Join Date: Apr 2008
Posts: 1
Reputation: TomV is an unknown quantity at this point 
Solved Threads: 0
TomV TomV is offline Offline
Newbie Poster

Sql Server generated Web Links result in "Page cannot be found"

 
0
  #1
Apr 14th, 2008
Hi ,

First post in this forum and hope this is the right area:

Website crashed and am rebuilding from scratch. Basically an ASP site, Data driven by SQL Server 2000 running II6 on Windows Server 2003 SP2.

Problem is that any URL links that are generated from a stored procedure in the SQL DB cause a Page Not Displayed 404 error.

When surfing you will see a link in the status bar that looks like www.mysite.com/notes/7.zip

In reality, through the SQL Server DB, the links might be redirected to www.mysite.com/note/paper/mypapers.zip using code similar to below (Mind you this worked fine until the crash) :

<a target=_new href=note/<%=rs("id")%>.zip><%=rs("num")%></a>

So it should redirect to the new link but for some reason we get a 404 error.
If we type the exact path in it works as advertised. But for some reason when retrieving the link from the Database it doesn't.

IIS Log files show an SC-Status of 404 , and the Sc-Win32-Staus code of 3.
I've checked every metabase setting and permissions I can think of and it looks good.

Used the METABASE XML File from the crashed server to create this site.

I'm thinking I've missed a setting somewhere and hope some one can help.

Thanks !!!
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



Tag cloud for ASP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC