registeration error help

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?

no one has any suggestions for this? meep!

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

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

yap i did :/

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 [Only registered and activated users can see links. Click Here To Register...]

if u need help i can help u ,
add my msn .
[Only registered and activated users can see links. Click Here To Register...]