Post reply

run an external program or call another functions

  • December 8, 2011 at 12:28 pm

    #253268

    hi

    i want to execute external programs or call another functions ( inside an ocx or dll) inside sql server 2000 (for example inside a sp).

    how can i do it

  • December 14, 2011 at 1:13 pm

    #1421573

    xp_cmdshell will allow you to call some things.

    The code inside SQL Server are not the same as say the code from a C# or VB program. You don't have an interface to link to a DLL.

    What you can do is install an extended stored procedure, which can be used to link to a DLL and call it, but you want to be very careful as you are then running something in process, and could cause instability.

    You can also potentially use the sp_OA procedures if you have a OLE/COM interface.

    http://msdn.microsoft.com/en-us/library/aa238863%28v=sql.80%29.aspx

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

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