Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding an Extended stored procedure Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 1:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:16 AM
Points: 2,826, Visits: 2,836
I am having some problems creating / using an extended stored procedure. (SQL 2005 sp 4) When trying to create a test environment, I knew that an extended procedure was needed which used dll xp_CTNHashProc.dll. So I duly ran :-
EXEC dbo.sp_addextendedproc N'xp_ctnhash', 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\xp_CTNHashProc.dll'

Then ran some code from the live server to prove the extended stored procedure was created correctly. It wasn’t, and returned :-
"Cannot load the DLL 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\xp_CTNHashProc.dll', or one of the DLLs it references."

So then I ran sp_helpextendedproc and my extended stored proc was there alongside it was the dll it should reference.

Running DBCC dllname (FREE)
Reports that “DBCC cannot free the DLL "xp_CTNHashProc.dll". The DLL is not loaded”


Does anyone have any ideas as to what is happening and how I can resolve it?
Thanks
Stuart


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1464476
Posted Tuesday, June 18, 2013 7:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:16 AM
Points: 2,826, Visits: 2,836
A bit of an update.

I have now found that the reason is one of the servers (where the dll works OK) is 32 bit, the other is 64.

I can only find one version on line for the 64 bit dll - this unfortunately does not work.

So my original question should now be:- Where can I get a 64 bit version of the DLL all google searches seem to take me to the same dll.


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1464633
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse