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: Friday, February 21, 2014 5:44 AM
Points: 8, Visits: 31

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: Yesterday @ 7:17 AM
Points: 179, Visits: 818
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: Today @ 6:21 AM
Points: 13,353, Visits: 10,213
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