Chum
Sep 26th, 2000, 09:12 AM
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
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