October 30, 2002 at 11:25 am
I've used Visual Studio and C++ to build a very simple dll, for use as an extended stored procedure. It builds fine. The dll gets put into C:\Program Files\Microsoft SQL Server\80\Tools\Binn. I load the extended sproc with:
sp_addextendedproc 'xp_GetSortKey', 'xpGetKey.dll'
That succeeds. I then try to use it:
EXEC xp_GetSortKey @nvcTxt OUTPUT, @nvcLocale OUTPUT, @nKey OUTPUT
I get an error:
Cannot load the DLL xpGetKey.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Anyone know what's going on?
Steve Miller
November 1, 2002 at 3:39 pm
Datf comment but does the dll reference anything that is not registered on the sever?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 1, 2002 at 4:23 pm
May be a sytax error where you did not properly specify the interface. I have a small one at work I threw together serveral months ago I can send to you to compare. Just email me so as a reminder. Generally it is the simple things in C++ that blow you up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply