how i can save image in sql server 2008

• gamit124

  SSC Veteran

  Points: 268

  More actions

  March 28, 2013 at 1:20 am

  #291595

  hi every one

  i am using vb 6.0 and i want to save my image in sqlserver 2008 how can i save and retrieve image from sqlserver

• Ness

  SSCarpal Tunnel

  Points: 4282

  More actions

  March 28, 2013 at 3:35 am

  #1601507

  Perhaps look along the filestream options in SQL server or varbinary datatypes

  SQL DBA
  Every day is a school day, and don't trust anyone who tells you any different.
  http://sqlblogness.blogspot.co.uk

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  March 28, 2013 at 3:45 am

  #1601512

  gamit124 (3/28/2013)

  ---

  hi every one

  i am using vb 6.0 and i want to save my image in sqlserver 2008 how can i save and retrieve image from sqlserver

  Typically you would store them in a varbinary(max) column.

  A (very old) example for VB6 (how ancient) can be found here:

  Save Data in a SQL Server Image Column with VB6

  It uses an image column, but since this datatype is deprecated I would use the varbinary(max).

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP