I recently moved a database from one server to another and
uses DTS to import the data. I now get the following
error on one of the pages of the website using the
database.

Microsoft OLE DB Provider for ODBC Drivers
error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
insert the value NULL into column 'id',
table 'watermind.watermind.ProductOrder'; column does not
allow nulls. INSERT fails.

Anyone know how I can fix this?

It sounds as though the ID field is an identifier field and this is by default non-null. You either have to devise a way to populate that field, or you must define a different key field and remove the identifier designation from the existing schema

Regards
John Miceli

You do not say if you repointed the website to this other database and
therefore are erroring on the migrated DB. From the text it sounds like you
are now erroring on the original databases by virtue of doing the transfer.
The latter is unlikely if nothing else has been done to that database. If
the situation is the former then it sounds as though the id attribute of the
ProductOrder entity does not allow NULLs and you are trying to insert one.
Is this on the migration of the database to the new database or has that
happened already?


"frank" <anonymous (AT) discussions (DOT) microsoft.com> wrote