Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC error or what is it?

Status
Not open for further replies.

babeo

Technical User
Mar 30, 2000
398
0
0
CA
Hello,
I am not so sure this is database error or the program error, could you help?
Error:
[red] Microsoft OLE DB Provider for ODBC Drivers error 80040e14

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint PK_closed. Cannot insert duplicate key in object Order_closed.

/pages/order/Order_Edit.asp, line 629 [/red]
Thanks
 
it's not a database or program error, it's a data error

the message is pretty explicit -- there's already a row with that particular PK value in the table, and you cannot add a second

r937.com | rudy.ca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top