March 28, 2013 at 1:20 am
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
March 28, 2013 at 3:35 am
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
March 28, 2013 at 3:45 am
gamit124 (3/28/2013)
hi every onei 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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply