We help IT Professionals succeed at work.
Get Started

Saving a PDF file in SQL Server (2005) or using the FileSystem and a path in db (VB 2005)

1,692 Views
Last Modified: 2013-11-26
OK, i have read various different opinion on whether a file should be inserted into a database, or whether it should be accessed through the filesystem.  I really havent made up my mind which way to go on this, but i can already think of a few problems with both.  I hope someone can help.

If you store the PDF inside a SQL database (lets say using an Image type), when you want to retrieve it...how do you view it?  Ordinarily, with a file i would view with either the webbrowser control or the adobe reader activeX control, but both need a filename/source and dont seem to be able to view from a memorystream or byte array.

If i store the file using the filesystem on the server, and store the path in the database...how does a local user retrieve the file when they are working offsite, remotely?  They can access the file using the path to the server when they are connected on the LAN, but when they are not, and just accessing the SQL server through the interner, how do they get access to the files then?

I would really like to know the best way to proceed as both ways seem problematic, yet i do need a solution.

Thanks so much,

Jeff
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE