DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Random ORA-00001: unique constraint violated error with Microsoft OLE DB

601555Dec 1 2008 — edited Dec 3 2008

Hi,
We have a VB6 process inserting records to Oracle database table(10g).
The process fails at random records with error message:
Error number: -2147217873.
Error source: Microsoft OLE DB Provider for Oracle.
Error description: .
ORA-00001: unique constraint (<constraint_name>) violated

We did exhaustive analysis of the input data and there are no duplicates to constraint the unique constraint.

Three Questions :
1) Have anybody faced this issue with Microsoft OLE DB Provider for Oracle. ?

2) Is Microsoft OLE DB Provider for Oracle known to work well with with 10g server?
On client side we have oracle 9i libraries.
3) Is Microsoft OLE DB Provider for Oracle reporting a wrong error?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2008

Added on Dec 1 2008

#9i, #client, #odbc, #windows-and-net

1 comment

3,204 views