Sql Error

[dawe007]

Hi, i have little problame...

I put this sql quarry:
exec account.dbo.cabal_tool_registerAccount 'acc','pass'

and Execute...

Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

and have this code....

Results:
usernum:
1:NULL


Whats have problame? thx help.

[MentaL]

[Divine Gift]

ok well im newb at this stuff so dont take my word for sure.

but if im right i think your sposed to put account name where 'acc' is and its pass where 'pass' is. lemmy know if that helps at all

[chumpywumpy]

You know if you search on these errors you might find your answers. This is one of the oldest problems and there are literally hundreds of posts about fixing it.

Your xp_md5 support is not working and the database cannot encrypt passwords.

Find xp_md5 in the "extended procedures" folder of the "master". Check it's properties and make sure the path to the dll is correct and that the permissions on the dll allow access to it. You can run the query below to see if it is working, if you get NULL it is not and if you get letters/numbers it is.

select account.dbo.fn_md5('test')