registeration error help

[firefox1985]

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'USER_PROFILE' when IDENTITY_INSERT is set to OFF., SQL state 23000 in SQLExecDirect in C:\xampp\htdocs\DkServer\register.php on line 81

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'Tbl_user' when IDENTITY_INSERT is set to OFF., SQL state 23000 in SQLExecDirect in C:\xampp\htdocs\DkServer\register.php on line 82

i keep getting that ive redone all the steps any tips?

[firefox1985]

no one has any suggestions for this? meep!

[xOWNEDGEx]

dude i have the same ******* error, i dont know whats ******* wrong

[gedimazs]

Have you created a system dns odbc driver linked to "account" database?

[firefox1985]

yap i did :/

[gedimazs]

Ok I have found what is the problem. I will paste some comments about that error and you decide where to go and fix it. First of all it is the MSSQL error.

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON
Don't forget to turn it back off again after!

SQL Server will automatically update its generated IDs to ensure you don't get duplicates after the insert;


the ASP pages were trying to insert data into the ID field which was set as an autonumber.


Now I'm at work so can't take a look at my DB and say anything. But when I will come back home I will take a look at it.

Edited: Try to read this one. I think this will help you

[lelothebest]

if u need help i can help u ,
add my msn .