Inserting a image into sql server 2000

[solo1234]

Hello everybody,

Configuring fields into a table of sql server 2000 you can to select an image.

Can someone tell us how to insert an image into such a field. We can calculate the the binary string of an image.

Nice regards,
Michelle.

 

[fredericofonseca]

Are you using plain T-SQL to do it, or will you be using an external language?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[mikeraut]

Hint: use blob

 

[solo1234]

Hello fredericofonseca,

We are using VB60, we can call an sql statement for inserting data but an image we don't know how to do.

Michelle.

 

[fredericofonseca]

Ok. This question would have been better answered in forum222.

but what you need to do is (using ADO) to look at the appendchunk method of the FIELD object.

see

http://support.microsoft.com/kb/180368

for a example

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[solo1234]

Everybody,

Thanks for the information!

Michelle.