Solved

Creating an Extended Stored Procedure

Posted on 2004-10-21
292 Views
Last Modified: 2010-05-18
Can anyone confirm if you can actually create a DLL which can be used as an Extended Stored Procedure - and if so let me know where I am going wrong please.

I have created my app which works fine as a EXE but when I add it to SQL and try execute the Extended SPROC I get
Cannot find the function  xxx in the library xxx.dll. Reason: 127(The specified procedure could not be found.).

Any help is much appreciated.
0
Question by:PUMASOFT
    1 Comment
     
    LVL 22

    Accepted Solution

    by:
    Extended procs must be in dll format.

    As far as I know, you cannot currently write stored procs from vb.net, it must be C++ (and not using managed extensions, at least I've never been able to get managed extensions working in one).  I've been told that in SQL 2005 you will be able to write in C# and VB.NET, but not until then.

    As well, it is not just a general DLL, there are specific functions that must be exported, and specific variables that must be used internally in order for sql server to be able to read it.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Anonabox PRO Tor & VPN Router

    PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

    Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.

    934 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now