Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having Problems Inserting A Binary Image Into SQLServer.

Status
Not open for further replies.

ctau

IS-IT--Management
Feb 8, 2000
34
US
I am having problems taking a binary file such as an image and inserting it into a SQL Table. I have used a statement to convert the image into an array of bytes like this:


Dim buffer(objStream.Length) As Byte

objStream.Read(buffer, 0, objStream.Length)

This works fine and then I can do a Response.BinaryWrite(buffer) and write the image out to the browser. My problem is that I can not figure out how to place the image into a simple insert statement. Any help would be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top