Accsessing Images Stored in a SQL Server database

[Maheshkshirsagar]

I have stored images in SQl database with their datatype as binary using "insert" statement.This works fine.
Problem comes whenever i tries to accsess that images
I use
"Imag1" control to do so
Whenever I calls .filename property
I am shown Error messege saying "path/file accsess error"
I am using recordset to get Images like
Image1.pictire=rsImage("Photo&quot where photo is my field name
can anybody help me?
Project deadline is 10/11/00

 

[fizz99]

Yuou have to use the GetChunk method of the field Object. Blob data such as Image or Text datatypes if using SQl Server can not be read conventionally because of the way it is stored on the database in linked pages. Look up GetChunk in the help and follow the instructions.....


Fizz

 

[TrivImp]

That's all well and good, but after you use GetChunk to read your image into a variable, how do you use it? I have:

lngLogoSize = rs("logo&quot.ActualSize
lngOffset = 0
Do While lngOffset < lngLogoSize
varChunk = rs(&quot;logo&quot.GetChunk(conChunkSize)
varLogo = varLogo & varChunk
lngOffset = lngOffset + conChunkSize
Loop
picImage.Picture = varLogo

I am getting an &quot;object required&quot; error on the last line & know I'm missing something, but I can't figure out what. Help Please ....