Storing .pdf files in SQL-Server -- sql server new users

sql server new users : Storing .pdf files in SQL-Server

Jeff Boyce
12/30/2004 9:35:43 AM

I noticed that SQL-Server has an "image" type field. How can I store a Word
document, or a .pdf file in that field, and retrieve a copy to inspect?

Thanks

Jeff

Jeff Boyce
12/30/2004 1:39:48 PM

Thanks, Fredrik.

In addition to the C# approach, does anyone have a VB/VBA solution, too?

Thanks, all!

Jeff

[quoted text, click to view]

Jeff Boyce
12/30/2004 2:37:17 PM

Once again, thanks! Happy New Year!

Jeff

[quoted text, click to view]

Fredrik Wahlgren
12/30/2004 9:29:34 PM

[quoted text, click to view]

The type you should use is called BLOB. Here's a C# sample:
http://www.akadia.com/services/dotnet_read_write_blob.html

/ Fredrik

Fredrik Wahlgren
12/30/2004 11:11:53 PM

[quoted text, click to view]

These articles may be of interest to you. One covers VB.NET, the other VB6.

http://support.microsoft.com/kb/316887/EN-US/
http://support.microsoft.com/kb/194975/EN-US/

/ Fredrik

Fredrik Wahlgren
12/31/2004 12:32:03 AM

[quoted text, click to view]

You're welcome. Happy New Year!

/ Fredrik

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn