May 6, 2012 at 12:27 pm
Hello
I am using a website that connects to a sql 2008 database and creates accounts by using MD5 function. I have used sql 2000 before and everything worked smooth, but now when it creates the account it leaves the field blank inside database and shows a md5 function error.
I have tried to edit the accounts manually with a software editor and i get the following error
SQL could not load the DLL WZ_MOD5_DLL, or one of the DLL s it reference.
Reason 103 (1% is not a valid application)
I am using windows server 2008 R2 SP1. I have used sql 2000 before and had no problems
The md5 functions that needs to be applied to the database so the website will work fine creating accounts is
USE [GDatabase]
GO
/****** Object: UserDefinedFunction [dbo].[fn_md5] Script Date: 05/06/2012 21:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END
GO
May 6, 2012 at 3:33 pm
That is not a SQL Server function. It's an extended stored procedure that you have to register on the SQL Server.
http://msdn.microsoft.com/en-us/library/ms164653%28v=sql.100%29.aspx
May 6, 2012 at 3:36 pm
yes
The problem is i have added everything i done on sql2000 but on sql 2008 i get that error and it;s not working
I have added the dll to binn folder and did everything right. This happend since i installed 2008
Anyone can help?
May 6, 2012 at 3:44 pm
And the XP registered correctly? You ran sp_addextendedproc? The DLL has to exactly match the function you register.
Is the DLL x64 if the server is x64?
May 6, 2012 at 3:47 pm
yea it s registered correctly
and i ve ran sql 2000 before on same OS windows 2008 x64 with same dll
XP_MD5_EncodeKeyVal already exists in master database
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply