| | |
Sql Server generated Web Links result in "Page cannot be found"
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Apr 2008
Posts: 1
Reputation:
Solved Threads: 0
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 !!!
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 !!!
![]() |
Other Threads in the ASP Forum
| Thread Tools | Search this Thread |
Tag cloud for ASP
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit web webserver windows7





