Post reply

Calling a DLL written in C directly from the database

  • February 3, 2005 at 6:31 am

    #361934

    Hello,

    I would like to know if there is a way to call methods in an existing dll directly from the sql code in SQL Server.

    In other words: I have a dll written in c. Is there a way to call it directly from the sql code?

    Thanks,

    Marcelo

  • February 5, 2005 at 12:16 pm

    #540818

    In Books On Line,look for sp_oacreate and all other method starting with "sp_oa"

    Hope that helps.


    paul

  • February 5, 2005 at 2:28 pm

    #540824

    Thanks, Paul

    Found what I was looking for =c]

  • February 7, 2005 at 3:29 am

    #540877

    Just to add. Since this DLL is written in C, you might want to consider adding it as your own extended procedure with sp_addextendedproc

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 10, 2005 at 7:48 am

    #541573

    Hmm... Interesting, Frank.

     

    I actually just made a stored procedure and called the OA methods to create the object and call the methods in the dll...

    But how would I create an extended stored procedure for this? Have you got any code you can share, or a step by step tutorial?

    Thanks for the reply

  • February 10, 2005 at 8:00 am

    #541580

    When you search BOL for "extended stored procedures" you'll find a basic example. In addition, this might be interesting. http://www.codeproject.com/database/xp_md5.asp

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply