Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how i can save image in sql server 2008 Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 1:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 5:37 AM
Points: 8, Visits: 32

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
Post #1436288
Posted Thursday, March 28, 2013 3:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:33 AM
Points: 179, Visits: 840
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
Post #1436334
Posted Thursday, March 28, 2013 3:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
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).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1436340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse