Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    1

    Unanswered: Attaching files to sql database

    Hi,

    I want to attach a pdf or doc or xls or any other file type to an tuple in the database.
    I am fairly new to databases. Also, I want that field that contains the link to the file to be an active link. I want to click on it and the file should open.

    Please help me out on this.

    By the way, this is a completely standalone database. This is not connected to any web server or anything and the files are stored in the computer hard drive itself.

    I am using MS Sql 2000 Enterprise edition.
    The basic gist is to create a DB so that we can open files from there without having to search for it as to where in the computer it is stored.

  2. #2
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    The way you are trying to access the files from sql server is not possible...
    In sql server you have to create a table and insert the data into a table....to store the pdf or doc or xls file you have to use TEXT data type...

    Check the following...
    How to store PDFs in SQL SERVER 2000
    Storing and Retrieving doc/pdf/xls files in SQL Server Tech Treasure
    MohammedU
    SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •