Hi,
Thanks so much for your reply.
I have gotten to a stage whereby I can create an instance of the object but cannot execute any of its methods. I keep on getting an 'Bad Variable Type' error.
The object is written in Delphi I think, the method is below:
function Logon(OperatorGroupID: Integer; const OperatorLogon, OperatorPassword: WideString; out ReturnValue : Integer): HResult; safecall;
My SQL is below: (@ID smallint, @return int, @login varchar, @password varchar)
EXEC @hr = sp_OAMethod @object, 'Logon', @RETURN OUTPUT, @id,@login , @password
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
Thanks again for your help, muchly appreciated.
Kind Regards,
Brett