October 24, 2004 at 9:05 am
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
October 25, 2004 at 6:03 am
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.
October 25, 2004 at 6:10 pm
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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy