all groups > sql server programming > february 2005 >
You're in the

sql server programming

group:

API functions


API functions mtgoli
2/15/2005 10:57:02 PM
sql server programming:
hi
How can I use an API function in a stored procedure in sql server 2000?

RE: API functions John Bell
2/15/2005 11:35:02 PM
Hi

Not directly! You may call a COM object using the sp_OA* procedures or write
an extended stored procedure. Depending on what you may want to do there may
be a procedure that already provides the functionality or an alternative
method of untaking the task.

John


[quoted text, click to view]
RE: API functions mtgoli
2/16/2005 1:35:03 AM


[quoted text, click to view]

Dear John
Can u please introduce som references about using COM object in sql? I've
never worked with COM object.

Re: API functions John Bell
2/16/2005 4:54:31 AM
Hi

This is an example:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_2ktw.asp

Searching for sp_OACreate on msdn.microsoft.com or google should turn
up more!

John
AddThis Social Bookmark Button