I can't write data to sql 2005

 

i have big problem now, can me?

i have program used asp+sql2000 ,the connection string :

strconnection = "provider=sqloledb;server=boun\windows,1005;user id=training;password=training22;database=ourtraining;"

everything works fine, can insert data, delete or modify.

but since changed sql2000 server sql 2005 express, can read data can't insert data(write data sql 2005)

i checked permission correct on sql 2005, program correct, looks good, can't write data sql2005

 

 

can me????

you have changed database schema. here's problem:

 

error details:-
microsoft ole db provider sql server
cannot insert value null column 'thread_id', table 'windtraining.dbo.tblthread'; column not allow nulls. insert fails.

table tblthread not allow null inserted thread_id. believe primary key column. please check application/database consistency:

• either make sure application not trying insert null
• or allow nulls inserted in column

SQL Server  >  SQL Server Data Access