SQL Extended Stored Procedures

• • Reply

  18 years ago

  by Matt Smith

  Matt Smith

  England, United Kingdom

  Joined 18 years ago

  Hi All,
  

  
  Dear All,
  

  
  I am testing the use of extended stored procedures using SQL Server 2000.
  I have written an Active X DLL written in VB6 which simply writes a record back to a table in the same SQL Server.
  I have registered the DLL.
  I have registered the DLL with SQL Server using sp_addextendedproc 'InsertRecord', 'c:\winnt\system32\Test.dll'.
  InsertRecord is a public function in a class in the DLL.
  When I try to execute the extended stored procedure using exec InsertRecord, I get the following error:
  Cannot find the function InsertRecord in the library c:\winnt\system32\Test.dll. Reason: 127(error not found).
  

  
  I have made sure that the function name in the DLL is exactly the same case as the one used in the sp_addextendedproc call.
  

  
  I have read on other forums that extended stored procedures cannot be written in VB, only C/C++, but I have not seen this confirmed anywhere. The Microsoft documentation states that any language capable of creating DLLs will work. Does VB conform to the Extended Stored Procedure API?
  

  
  Can anyone advise me on this one?
  Cheers,
  Matthew Smith.
  [email protected]
  

  
  

  Report abuse