469,277 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

How to call DLL file from sql server 2005

27
How to call a DLL file from sql server 2005

and how to use it function.... using sql server 2005
Jul 25 '10 #1
3 3549
PsychoCoder
465 Expert Mod 256MB
You have two options for accomplishing this:
  1. Extended Stored Procedures:
    You can use the procedure sp_addextendedproc (located in the system database) to register the DLL, then you can call it. This is an example of how it works:

    Expand|Select|Wrap|Line Numbers
    1. use master
    2. Go
    3. sp_addextendedproc "MyFunction", "C:\Windows\MyDLL" 
    4.  
    NOTE: Keep in mind that this method is Deprecated but you can accomplish it this way
  2. CLR Objects:
    You can create CLR objects in .Net; such as stored procedures, user defined functions, etc, then register it on your SQL server as an assembly

Hope that helps :)
Aug 2 '10 #2
MrMob
27
Thanks For the POST

Richard..

I will be Happy Enough i get any Clue to use
the Dll File and it Function..

iN sql server 2005

with some good Examples..

Thankyou..
Your Follower..
MrMob...
Aug 11 '10 #3
NeoPa
32,172 Expert Mod 16PB
MrMob: I will be Happy Enough i get any Clue to use
the Dll File and it Function.
You should be happy then, as Richard provided that and more.

You should understand that we're not here to do your work for you. You have the pointers. If that's still not clear then please explain carefully and clearly what you don't understand.
Aug 11 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.