Solution: ADO SqlServer TimeStamp from _variant_t byte array in c++



_variant_t vtValue;
VariantInit(&vtValue);

if (FieldTypes[i]==adBinary)
.....
....
vtValue = m_Rec->Fields->GetItem(vtIdx)->Value;

' get the size
int Count=vtValue.parray->rgsabound[0].cElements;
char st[256],TimeStamp[256]; ' Alloc to atleast (Count*2)+16.

' get the byte array ptr
unsigned char *p=(unsigned char *)vtValue.parray->pvData;

strcpy(TimeStamp,"0x");
for(i=0;i<Count;i++)
{
sprintf(st,"%02x",p[i]);
strcat(TimeStamp,st);
}

.