SQL Server Performance

Sample ASP or PHP To Retrieve

Discussion in 'SQL Server 2005 General Developer Questions' started by photojazz, Oct 12, 2006.

  1. photojazz New Member

    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
  2. Akthar New Member

    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 www.asp101.net





    AKTHAR
  3. photojazz New Member

    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

  4. Akthar New Member

    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

Share This Page