[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Creating an Extended Stored Procedure

Posted on 2004-10-21
3
Medium Priority
?
293 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
Comment
Question by:PUMASOFT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 23

Accepted Solution

by:
Snarf0001 earned 2000 total points
ID: 12371883
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

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

656 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