I have a wee problem with the INSERT statement. The problem is very unusual problem. I would like yours help in the same. The problem is.... Mine files are running very well on my IIS but when i posted on the net, it prompts me error messages. The error which it prompt is...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition.
/minorities/postrec.asp, line 34
In brief, i would like to put some lights on the code and database. It's a very simple program in which user fill up their events details in the form and the vaules of that form is going to store in the database.The database contain one "AUTO-INCREMENT" fileds which is increment by 1 every times a new records is added. I am using SQL 2000 and ASP.
Server: Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'recruitment' when IDENTITY_INSERT is set to OFF.
Without identity or with (SET IDENTITY_INSERT recruitment ON):
Server: Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'recnum', table 'recruitment'; column does not allow nulls. INSERT fails.
The statement has been terminated.