HK Registration Script Help

[syntaxjedi]

$query = "INSERT INTO [Account_CN].[dbo].[tUser] ([nUserNo],[sUserID],[sUserPW],[sUserName],[bIsBlock],[bIsDelete],[nAuthID],[sUserIP],[dDate]) VALUES('".rand_string()."','$_POST[username]','$_POST[password]','$_POST[password]','False','False','1','127.0.0.1','CURRENT_TIMESTAMP)'";

this is my insert line, and I keep getting an error that says.

Warning:  odbc_exec() [function.odbc-exec]:  SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert  explicit value for identity column in table 'tUser' when  IDENTITY_INSERT is set to OFF., SQL state 23000 in SQLExecDirect in C:\wamp\www\Register\index.php on line 130

[MentaL]

[Wicious]

"Cannot insert explicit value for identity column in table 'tUser'" should be enough to go on, you can't insert a value in an auto increment column. (nUserNo)

[syntaxjedi]

"Cannot insert explicit value for identity column in table 'tUser'" should be enough to go on, you can't insert a value in an auto increment column. (nUserNo)

Got it to work.

[fiestanerd69]

Closing thread seeing as the issue has been solved.