Calling a DLL written in C directly from the database

Question

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

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

sqlemail@yahoo.com SSC Eights! Points: 919 More actions · Answer 1

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

Hope that helps.

paul

Marcelo Trein SSC Journeyman Points: 80 More actions · Answer 2

SSC Journeyman

Points: 80

February 5, 2005 at 2:28 pm

Thanks, Paul

Found what I was looking for =c]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

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]

Marcelo Trein SSC Journeyman Points: 80 More actions · Answer 4

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

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]

Cookies on SQLServerCentral