I'm working on an application in VB, ADO and ODBC which is supposed to read the contents of a table in MS SQL and insert the rows read from that table into a similar table in DB2.

It all seems to work except for when the table contains one or more columns holding VarBinary data.

How to I get VarBinary converted so that when I insert into the DB2 equivalent as VarChar For Bit Data it actually succeeds and the contents are the same in MS SQL as in DB2.

Any help on this would be greatly appreciated.