Sample ASP or PHP To Retrieve | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sample ASP or PHP To Retrieve

First, thanks to the forum for answerin my newbie (new to SQL) questions.
With the advice recived, I have decided to link my docs to the database instead of storing them within the database itself. I woulld like to setup a ASP or PHP page to that will allow users to access the word documents via a web page. Can anyone suggets a tutorial or have samples of how I might do this? Thanks in advance! Spencer
hello, 1. Good idea to store links to documents instead of the doc itself.
2. You must store the documents where it will be accessible by your web Server. Are you using IIS as web Server?
if you are using asp then you can dynamically build your link to the documsnt for e.g: ‘build your database connection
connobj, connstr, recordset
response.write "<A href=" & recordset.fields(doclink) & ">Document Link</A>"
%> Hope this helps
Have a look at AKTHAR
Thanks Aktar, I have an IIS webserver.
Can the files be stored on a file server or the database server and the asp page point to either of those locations? Spencer
Yes you can choose the file server option. becarefull as it must be your web server who access the files and not the webuser for security issues AKTHAR