>>I would need to check, first, if CA support Character (Binary) type field. That is, if you can map a Binary field in SQL Server to Character(Binary) in VFP
This is where version of ODBC driver plus VFP handling of some field types can bite you. Chen did quite a bit of work to fix mapping of map field types SQL->VFP in VFPA so if binary bites you, maybe check his FAQ/bug fix list.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1