insert using cfinsert

[surenr]

I have been trying to upgrade my server from CF 5 to CF 7. I have a table as
keywords with the attributes as follows:
ID int (primary key)
keyword char

In form 1 the code is as follows:

<form name="InsertKeywords" action="form2" method="post">
<input name="keyword" type="text" maxlength="255">
</form>

In form 2 the code is as follows:
<cfinsert datasource="EMP" tablename="keyword">

As the ID is a primary key the system automatically generates a unique key and
inserts into the DATABASE,Suppose if the database had the following:

Metal 10
Chalk 11

The next keyword will have the ID as 12.It used to work earlier,now i get this
odd error:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value
NULL into column 'ID', table 'EMP.dbo.keyword'; column does not allow nulls.
INSERT fails.

Any help or suggestions would help.

[SteveBryant]

Double check in your database that the Identity property of your ID field is true. SQL Server won't increment just because a field is a primary key. It incremenets based on the Identity property.