ADO and VC++ and SQL Server

i have been using Access/Jet wrapped by ADO for my db.
i have upgraded to SQL Server but now i am not able to
write to the SQL Server db. I have checked permissions
(i am dbo of all tables), cursorType(dynamic), lockType(optimistic),
the db is opened as read/write, i have adUseClient set,
there is a primary key on all the tables, when i check
recordSet->Supports it shows Add,Update,MoveForward,Delete
are all supported.

the error i get is -2147217873 (speciifed value violated the integrity constrains for a column or table).

i've followed all the threads i could find in the forum relating
to this problem and i'm still stuck.

any help would be appreciated!!!!!

tashikit