Can't load dll

• Undebtedly

  SSCrazy

  Points: 2938

  More actions

  October 30, 2002 at 11:25 am

  #159186

  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

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  November 1, 2002 at 3:39 pm

  #440111

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 1, 2002 at 4:23 pm

  #440120

  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.