Creating an Extended Stored Procedure

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.
LVL 2
PUMASOFTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Snarf0001Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.