Recompiled xp_md5.dll for x64

[coolpriest]

I am stucked on the databases because xp_md5.dll is 32 bit and ceases to function when migrating to 64 bit environment. So i recompiled the source with Visual Studio 2008 and .NET 3.5 framework. I have not tried it yet and I hope it will function as intended.

Download .NET 3.5 from Microsoft.

http://download.microsoft.com/downlo...dotnetfx35.exe

[MentaL]

[phiber]

excelent contribution ^^

[mjsamet]

really good job

[sevenmore]

Gotta scream and shout, THANK YOU!

[Zell Dinch]

Does it work properly? I tried to use it but almost useless. I renamed the file 'xp_md5.dll' , put it in C:\Windows\System32 , execute exec SP_ADDEXTENDEDPROC 'xp_md5' , 'xp_md5.dll' successfully. But when i tried
exec dbo.cabal_tool_registerAccount 'yourusername' , 'yourpw'

It returned

Server: 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.
Server: 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)

[coolpriest]

Does it work properly? I tried to use it but almost useless. I renamed the file 'xp_md5.dll' , put it in C:\Windows\System32 , execute exec SP_ADDEXTENDEDPROC 'xp_md5' , 'xp_md5.dll' successfully. But when i tried
exec dbo.cabal_tool_registerAccount 'yourusername' , 'yourpw'

It returned

Server: 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.
Server: 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)

Yes it works on Window$ XP 64Bit and SQL2005 x64. It is not really necessary to place the file in C:\Windows\System32. You can place it anywhere and just point its location, try doing something like this:
exec SP_ADDEXTENDEDPROC 'xp_md5' , 'c:\md5\xp_md5.dll'

This is what I did with my PS...

[Rinaldo.Zanzini]

congrats!!! tks!!

[LostSpirit]

humm dll not work for me

dll , run on sql2000?

[cypher]

yes i tested it on mssql 2k on ms 2k3 svr x64

[cheeky_rzone]

I've tried also using this xp_md5.dll in a 64-bit Server 2003 and 64-bit SQL 2005 server, was successfully executed.

But still, registration have the following error:
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
Using GM Tools also have error: duplicate or already exists

Any idea please to resove this issue?

[vadkan11]

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.

(0 row(s) affected)
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.

(0 row(s) affected)

(1 row(s) affected)

Im using Windows 2003 x64 and MSSQL 2005
I configured good the xp_md5.dll but doesn't work.

[chumpywumpy]

People have trouble setting up the 32-bit version of xp_md5 so i seriously doubt there is anything wrong with the dll as i know a few people that run on x64. The problem is almost always that the dll is not where it is supposed to be or for some reason security permissions are preventing mssql from accessing the dll. Find it's entry in the "extended procedures" folder of the "master" database, check the properties and make sure the .dll is in the right place. If it still doesn't work then try moving the dll to another folder, deleting the xp_md5 entry and re-registering it as i have heard of more than a few problems that were caused by folder permissions.

Also make sure you check these two posts out:

http://forum.ragezone.com/f460/tips-...er-pcs-455417/

http://forum.ragezone.com/f460/cabal...-guide-462114/

[Alphakilo23]

Works with SQL Server 2008.
Awesome, thank you!

[daniadane]

Thanks. It works on sql2008 64bit machine.

[Spectro]

Thanks. It works on sql2008 64bit machine.

x64 xp_mp5.dll isnt safe....