registeration error help

firefox1985 · 07/11/2009, 03:46

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 · 07/13/2009, 09:57

no one has any suggestions for this? meep!

xOWNEDGEx · 07/14/2009, 07:24

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

gedimazs · 07/14/2009, 09:33

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

firefox1985 · 07/14/2009, 09:40

yap i did :/

gedimazs · 07/14/2009, 10:01

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~~ · 07/14/2009, 10:47

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