Registering x32 dll for extended sp in SQL server 2005 x64

Question

Registering x32 dll for extended sp in SQL server 2005 x64

FelixG

SSCrazy

Points: 2550
More actions
October 16, 2009 at 11:00 am

#227150

I've been using the DBA toolkit (http://www.sqlservercentral.com/columnists/mcoles/DBAToolkit.zip) for a long time in my production server running Windows server 2003 (x32) and SQL server 2005 (x32).
The installation of this toolkit is based on a script that registers some stored procs. Now I'm upgrading my production server to Windows server 2003 x64 and SQL Server 2005 x64, and when trying to execute one of those extended stored procs I get the following error message:
Msg 17750, Level 16, State 0, Procedure xp_create_master_key, Line 1
Could not load the DLL C:\WINDOWS\SysWOW64\xp_create_master_key.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
I have placed the DLLs in the MSSQL\binn directory and in windows\SysWOW64 but the error continues showing all the same.
Is there any way of installing xps compiled for x32 in x64 ???
Thanks in advance,
Felix

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26944 More actions · Answer 1

FelixG (10/16/2009)
I've been using the DBA toolkit (http://www.sqlservercentral.com/columnists/mcoles/DBAToolkit.zip) for a long time in my production server running Windows server 2003 (x32) and SQL server 2005 (x32).
The installation of this toolkit is based on a script that registers some stored procs. Now I'm upgrading my production server to Windows server 2003 x64 and SQL Server 2005 x64, and when trying to execute one of those extended stored procs I get the following error message:
Msg 17750, Level 16, State 0, Procedure xp_create_master_key, Line 1
Could not load the DLL C:\WINDOWS\SysWOW64\xp_create_master_key.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
I have placed the DLLs in the MSSQL\binn directory and in windows\SysWOW64 but the error continues showing all the same.
Is there any way of installing xps compiled for x32 in x64 ???
Thanks in advance,
Felix

Don't believe you can do this. You'll need to rebuild the XPs with a 64 bit compiler.

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

boyette Valued Member Points: 71 More actions · Answer 2

@Felix: Did you ever get this to work? I am running into the exact same error now. We're trying to use x64 for SQL 2008 (works fine in x32 for SQL 2008).

FelixG SSCrazy Points: 2550 More actions · Answer 3

Jason:

I did not find a solution for x64 platform... In my case I needed the SQL DBA Toolkit to use the Jaro-Winkler string similarity functions... Googled a lot and found some implementation of these functions in a library for .NET, built a CLR stored procedure and all is working fine in my SQL 2005.

Regards,

Felix