“Cannot load the DLL” Error In SQL Server 2005

Sometimes we need to install a dynamic link library to take advantage of extended stored procedure in SQL Server. So you have installed it through the Extended Stored Procedure GUI. You double checked that the dll exists in the MSSQL\Binn directory. But then when you tried to execute the procedure you received this Error: Cannot load the DLL C:\Microsoft SQL Server\MSSQL\Binn\dllname.dll, or one of the DLLs it references.