error code : -2147417848
error description : Automation Error


We are using ADO(DATA ENVIRONMENT) and SQL SERVER 7.0 as the back end. An error occurs when saving the data(when creating new record only).This happens only when the program is in excutable(.exe) while if you are in VB 6.0 Environment the Programs are ok(no BUGS).

Do you know any Microsoft patch for this type of problem with the compiler?