Solved

store image into SQL server database?

Posted on 2001-06-12
5
808 Views
Last Modified: 2010-05-18
hi there !

I want to use VB to store image, video clip files to SQL server database. I know SQL Server has image column, but what should I do now?


TIA

minh
0
Comment
Question by:minhdb
5 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 34 total points
ID: 6180772
I suggest that you look up the AppendChunk and GetChunk methods of the ADO fields objects.

Cheers
0
 
LVL 8

Assisted Solution

by:chigrik
chigrik earned 33 total points
ID: 6181315
To put binary data into image datatype, you can use textcopy utility.
Read about "Copy text or image into or out of SQL Server"
http://www.swynk.com/friends/achigrik/Textcopy.asp

You can also use AppendChunk() and GetChunk() method.
Location: SQL Server Books Online
Title:    Using Long Data Types

Hope this helps
0
 
LVL 5

Assisted Solution

by:dtomyn
dtomyn earned 33 total points
ID: 6181455
Actually, if you are using ADO 2.5 or 2.6 you can use the Stream Object.  See: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20460 for a good explanation
or another good source is planetsourcecode, ex. http://www.planetsourcecode.com/xq/ASP/txtCodeId.11531/lngWId.1/qx/vb/scripts/ShowCode.htm
0
 

Expert Comment

by:CleanupPing
ID: 9282238
minhdb:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now