INF: Extended Procedure Error: "Cannot find the DLL 'xxx.dll'"

Article translations Article translations
Article ID: 151596 - View products that this article applies to.
This article was previously published under Q151596
Expand all | Collapse all

SUMMARY

SQL Server generically returns this error message when there is a problem loading the extended stored procedure:
"Cannot find the DLL 'xxx.dll'"

MORE INFORMATION

There are several problems that you might experience. Among these are:
  • DLL not in the correct path.
  • Subsidiary DLLs, like MFC40.dll, not in the path.
  • Function not found.
  • Any other error that would cause the loading of the extended stored procedure DLL to fail.


There are a couple of techniques that you can use to identify the errors. First, you need to re-visit the path and make sure the DLL is in the path. Also double check the sp_helptext stored procedure for the procedure to make sure the name is correct.

If these efforts still do not identify the problem, you may be able to use the following code snippet to identify the error. The code loads the specified library, and tries to access the function. If it fails to load, it will print the associated operating system error message.
#include "windows.h"
#include "stdio.h"

// 
//    Functions
// 

typedef int (*fnInternal)(void);
void main(int iArgs, char *strArgs[], char *strEnvs[]);
void vUsage(void);

// 
//    Main function
// 
void main(int iArgs, char *strArgs[], char *strEnvs[])
{
   HINSTANCE   hLib        =  NULL;
   fnInternal  fCall       =  NULL;
   char     strMsg[1025]   =  "";

   if(iArgs == 3)
   {
      printf("\nAttempting to load %s - %s\n",
               strArgs[1], strArgs[2]);
      if( (hLib = LoadLibrary(strArgs[1])) != NULL)
      {
         fCall = (fnInternal)GetProcAddress(hLib, strArgs[2]);
         if(fCall)
         {
            printf("%s found and loaded successfully.\n",
strArgs[2]);
         }
         else
            printf("%s not found in %s.\n", strArgs[2],
strArgs[1]);
         FreeLibrary(hLib);
      }
      else
      {
         ::FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM,
                     NULL,
                     GetLastError(),
                     GetSystemDefaultLangID(),
                     strMsg,
                     sizeof(strMsg) -1,
                     NULL);
         printf("Error %ld %s\n", GetLastError(), strMsg);
      }
   }
   else
      vUsage();

   printf("\n");
}

// 
//    vUsage
// 
void vUsage(void)
{
   printf("\n"
         "Usage: Loadlib.exe libname function\n"
         "\n"
         "Where: libname  = 8.3 name of library\n"
         "       function = name of function in the library\n"
         "\n"
         "Example: loadlib xplog70.dll xp_msver\n");
}
				

Properties

Article ID: 151596 - Last Review: December 3, 2003 - Revision: 4.2
APPLIES TO
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbinfo kbprogramming KB151596

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com