Calling an API from SQL Server

• clarcombe

  Old Hand

  Points: 356

  More actions

  October 24, 2004 at 9:05 am

  #86823

  I have an API in Windows DLL form that I want to call from a stored proc using a cursor, passing in values from said cursor.

  Is this possible to do in either SQL 7.0 or SQL 2000 ?

   

  Thanks

   

  Colin

• Tim Curtin

  Say Hey Kid

  Points: 665

  More actions

  October 25, 2004 at 6:03 am

  #527788

  see the 'sp_OACREATE()' system stored procedure. this allows you to call COM api's.

  There are also 2 techniques:

  1.  either you register it with COM(regsvr32)

  2. or you install it in the SQL system tables and drop the dll in the SQL install folder /binn. Not sure of the SP to register it with SQL.

• Clay_G

  Default port

  Points: 1454

  More actions

  October 25, 2004 at 6:10 pm

  #527889

  You can setup a custom extended stored procedure to call a DLL function. I havent got the info, I googled:

  extended stored procedure SQLServer DLL

  and seems to be some info.