Odbc Driver Error?

Hi,

I have a thread in a C++ dll that inserts records into an SQL database (inside a while loop). Sometimes, depending on the records, it is able to finish inserting all records (exits the loop with no problems). Other times, it inserts say only 3 or 4 records and returns the following error:

Error : -2147217887 Msg:" IDispatch Error #3105 The requested properties can not be supported"

Have any of you guys encountered this problem??
I tried different lock types for openeing the recordset (when retrieving records to insert elsewhere).

Any help would be graciously appreciated.

Thanks.

Ryan

Are you sure all your input is valid?

Quote:

---

Originally posted by knutso
Are you sure all your input is valid?

---

to expand on what knutso is saying, are you sure your not violating any of your SQL table constraints. ie) proper data types, data within specified domains, foreign keys exist....

yes, the data fields are correct as it is able to insert more than 1 record each time. I believe that it could be that the cmd is trying to execute before the previous one is done 'inserting' (but how could this be possible, if it must loop once and then loop again to reach the next 'insert')???

Are you running SQLEndTran before the next insert? If not, the last insert wasn't commited..