Ok, I'll try to explain this as best I can. We have a program that uses SQL Server 7.0 to store its data. For some reason, it creates a proprietery 'hash' (or index) column that is of type 'binary.' Essentially, I need to populate this column with certain information.

My question is two-fold:

1) What VB data type should I use to feed SQL Server? I've seen a few articles concerning 'GetChunk' and AppendChunk' but have had no luck. I use ADO as my primary connection type. I've tried to concatonate a string of extended Ascii characters, but the Server Does not like that either.

2) After I have to data stored in proper form, should I try to use the .AddNew method? Or is there a better way in this situation.


Any help would be greatly appriciated.

Thanks,

Chad