binary data type in SQL SERVER

[faisalsham]

Hello All,

Does anybody know how can they read a binary data type from SQL Server.
I have a field in a SQL Server table where the data type is binary. I'm trying to read this field in VB,however all I get is "???????!????" something like this.

Is there a way to do this in VB?

Your help is greatly appreciated.

thanks in advance.

 

[fredericofonseca]

to deal with BLOB's you need to use the getchunk method of the field object (this if using ADO).


If you are using any other method of access SQL Server it may have a similar method, but you will need to tell us (and you should probably change to ADO anyway).

Using the field on VB may require that you save it to a file first, and then use whatever application/control uses that type of file.

e.g. if the binary field is holding a Word document then you need to use a Word object to process the file.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com