call dll from Sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I am able to call dll from sql server 2008 but sql server accepts only void return type. I have method in dll which returns object of the class and then call method of that object. How can I do this.

Posted 19-Jul-11 20:33pm

SatyaKeerthi15

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SanjeevSingh · Answer 1 · 2011-07-19T20:51:00

Solution 1

hello,

first register the dll using sp_addextendedproc and then
use master Go sp_addextendedproc ” FunctionName ” , ” Dll Path ”

hoping it will help you

thanks
sanjeev

Posted 19-Jul-11 20:51pm

SanjeevSingh

Comments

SatyaKeerthi15 20-Jul-11 3:21am

Did you understand my query. I have created the assembly and Stored Procedure. I can talk to dll method which have 'void' as return type. But I need to call the method which returns object of the class. How can I do this

SanjeevSingh · Answer 2 · 2011-07-19T20:53:00

Solution 2

or follow

http://sqlserver-training.com/can-we-call-dll-from-sql-server/-[^]

thanks
sanjeev

Posted 19-Jul-11 20:53pm

SanjeevSingh

Comments

[no name] 22-Jul-11 11:48am

There is no need to give multiple answers to the same question, if you want to improve your answer, use the 'Improve solution' link or add comments to your existing answer.