>I am not using PK field in my insert statement as i feel that it should be populated automatically.

Deepak,
I think you're right. Yesterday night I checked KB at home and somewhere it says via ODBC driver you cannot call stored procedure directly. Only rule and triggers invoke it. Maybe I'm interpreting it wrong (I don't use ODBC but COM interfaces) :
Q150149
It's about VFP 1.0 ODBC driver but seems to apply to current version.
Cetin