Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 a problem

Author  Topic 

ehudbino
Starting Member

4 Posts

Posted - 2008-07-31 : 09:13:31

I have this lines in my web site

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Violation of PRIMARY KEY constraint 'PK_SessionAction'. Cannot insert duplicate key in object 'dbo.SessionAction'.

/testi/include/infoMasterUtil.asp, line 720

in 720 i have this code

Conn.Properties("JET OLEDB:Max Locks Per File") = n

how can i solve the problem ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-31 : 09:17:13
You are trying to put duplicate value into your primary key column. Look for insert steps onto your table and see if value you're passing for primary key already exists in table. if you need more help,post your sql query
Go to Top of Page
   

- Advertisement -