Information on storing files in fields -- sql server clients

anonymous NO[at]SPAM discussions.microsoft.com
1/28/2004 9:37:56 AM

Hi again Billy,
After looking over both samples, I decided not to store
the files in the database at all. In my current problem I
foresee it taking up too much space due to file sizes.
Probably best in my situation the tried and true way of
storing filename and path. Thanks for your help on this.

Phillip

[quoted text, click to view]
<http://support.microsoft.com/support/kb/articles/Q194/9/75
..ASP>
[quoted text, click to view]
<http://support.microsoft.com/support/kb/articles/Q173/3/08
..ASP>
[quoted text, click to view]

v-binyao NO[at]SPAM online.microsoft.com (
1/28/2004 12:51:59 PM

Hi Phillip,

Thank you for posting in the community. My name is Billy and it's my pleasure to assist you
with this issue.

I think Mike has pointed out a source of how you can storing files (BLOB data) as a field in
SQL 2000. Here I follow up your issue with further informaion. Hope they will assist you
further.

The Example 2 in the following KB was used to import the image into the sql server image
datatype field, which mostly suits your needs. It is a very easy and commonly used method
by most developers, so I recommend you try this if possible.

258038 HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO
Stream
http://support.microsoft.com/?id=258038

For more resources on how to store and retrieve the data in the BLOB field, I provide you
with additional articles below:

194975 HOWTO: Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/?id=194975

HOWTO: Sample Functions Demonstrating GetChunk and AppendChunk
Q194975: <http://support.microsoft.com/support/kb/articles/Q194/9/75.ASP>

HOWTO: Displaying Images Stored in a BLOB Field
Q173308: <http://support.microsoft.com/support/kb/articles/Q173/3/08.ASP>

If there is anything more we can do to assist you, please feel free to post it in the group.
Thanks again for choosing Microsoft!

Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

v-binyao NO[at]SPAM online.microsoft.com (
1/29/2004 2:09:03 AM

Hi Phillip,

Thank you for your feedback! It's my pleasure to be of assistance.

Considering the big file sizes, storing only filename and path into the field may be a better
choice on your side. We are glad that the information provided to you is helpful. If there is
anything we can also do to help you, please feel free to post it in the group.

Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

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 clients

sql server clients : Information on storing files in fields