API Calls

• steinie

  Valued Member

  Points: 64

  More actions

  August 15, 2003 at 11:47 am

  #81015

  Does anyone know an easy way to make a Win32 API call from within a SQL 2000 stored procedure?

  thanks

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  August 18, 2003 at 5:55 am

  #470247

  One way I could think of is to wrap your API calls into a COM and instantiate and execute the COM using the sp_OA.... stored procedures.

  
  Joseph
  

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  August 18, 2003 at 6:11 am

  #470252

  Hi steinie,

  I don't think, that there is a direct way to call API functions.

  So you need to write a wrapper round it. Either COM or small exe.

  What function are you trying to call?

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]