Link to home
Start Free TrialLog in
Avatar of BlakeMcKenna
BlakeMcKennaFlag for United States of America

asked on

Storing a PDF File as an Image?

I'm saving a PDF file in a SQL Server DB. The column in the Table is defined as varbinary(MAX). I was wondering if the PDF can be stored as an Image DataType? If so, which is more efficient to do? Is there a better way altogether?

If you could provide a code example in VB.Net, I would appreciate it!

Thanks!
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

I usually just store the files location in a regular varchar column. Just be sure to store the full path (the full UNC is of course preferable).
Your VB program can then use the path's string value (eg. using the IO namespace...ie. IO.File.Open).
Avatar of BlakeMcKenna

ASKER

I already know how to do this. This isn't related to my question.
ASKER CERTIFIED SOLUTION
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks David...that's more what I was looking for!
Glad to help Blake!