Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Extended stored procedure in SQL SERVER 2005

Author  Topic 

ilan_thendral@yahoo.com
Starting Member

3 Posts

Posted - 2007-05-17 : 14:59:58
The error list below is the one we are getting when attemping to run the extended stored procedure

Msg 17750, Level 16, State 0, Procedure sp_HVC_helpDLL, Line 1

Could not load the DLL C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sp_hvc.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).


As per earlier test to run the extended stored procedure in SQL SERVER 2005 server,it was successful,the edition of the SQL SERVER 2005 was Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1).

The extended stored procedures are running fine even without the registering them with full path of the dll i.e. “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sp_hvc.dll”.

The same procedure was run in an another server with the following edition

Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright © 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1).

We suspect that the failure of the extended stored procedures might be due to the difference in SQL SERVER 2005 Editions.

Would this information do any help?
Can any one help
   

- Advertisement -