Extended Stored Procedures

G

Guest

I have written an Extended Stored Procedure and it works fine. In the installation intructions it is said that you must copy the .dll to SQLServer's binn directory. Why not put it in the GAC? (and ngen it!
/Folke
 
J

Joe Delekto

Greets,

The extended stored procedure is a normal Win32 DLL and not a managed
DLL (at least not yet). It requires being copied to that specific folder
because that is where the engine loads extension DLLs, using the
LoadLibrary()/GetProcAddress() Win32 API functions. It doesn't require ngen
because it's already native code. It's almost similar to an ISAPI filter,
only the IIS manager allows you to specify where that DLL exists.

Regards,

Joe

Folke said:
I have written an Extended Stored Procedure and it works fine. In the
Click to expand...
installation intructions it is said that you must copy the .dll to
SQLServer's binn directory. Why not put it in the GAC? (and ngen it!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Webservice call from extended stored procedure 4
Access Passing data from a form to another form! 0
creating extended stored procedure with Visual C++ 7 (vs 2003) 2
Input string was not in a correct format. 1
Asynchronous database calls 4
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Use c# for SQL extended stored procedure 1
Call extended stored procedure programatically? 1

Top