I am trying to execute some COM objects via a stored procedure.
I am using sp_OACreate to create
and sp_OAGetProperty to excecute a property that returns another object
Now when I try to run sp_OAMehtod against this returned object I get an error from sp_OAGetErrorInfo saying "
Element not found
I saw the documentation on sp_OAGetProperty and it does say that objects returned from the property can be used in other OLE automation stored procedures.
Can any body tell me why I am getting the error.
Thanks in advance
I am using sp_OACreate to create
and sp_OAGetProperty to excecute a property that returns another object
Now when I try to run sp_OAMehtod against this returned object I get an error from sp_OAGetErrorInfo saying "
Element not found
I saw the documentation on sp_OAGetProperty and it does say that objects returned from the property can be used in other OLE automation stored procedures.
Can any body tell me why I am getting the error.
Thanks in advance