Powering thousands of Online Stores, Shopping Carts, around the world!

PDshop is built on Asp.Net, works with ALL Windows web hosts and Windows servers!
Download Learn More
Microsoft SQL MSSQL Cannot insert the value NULL into column database message
Sample Error
SaveData Exception. Cannot insert the value NULL into column 'id', table 'dbo.items'; column does not allow nulls. INSERT fails. The statement has been terminated.
Solution or Workaround
The error suggests that your database's "id" columns properties have been changed, and the id column is no longer an autonumber/identity and primary key column.  This would present a huge problem, since the id column was originally designed to have the database itself automatically assign a unique number for the record.  The error you are getting shows that the id column is not assigning itself a number, this can only be fixed by properly re-migrating a database from Access to SQL or by properly re-moving the database from one server to another using Microsoft's backup/restore procedures in The MS SQL management tools.  

If you have the original database before the move or conversion, Contact Us and have us migrate/convert it for you.
Related Articles
Related Topics
Search for help...

IMPORTANT

IMPORTANT update for the new year 2024. All users should install the Latest Update. We recommend updating to 10.076 or higher as soon as possible.