SP_OA dll fun

[Malcav]

Hi
Searched and googled but could not find the answer to this.
I have c:\x.dll
have tried
exec sp_oacreate 'c:\x.dll', @object OUT
and get the 'invalid class string' error

I need to call 'FindGuy' with the parameters
"Dude|111",60
am using
exec sp_oamethod 'FindGuy' @person OUT, "Dude|111",60

any ideas what I have done wrong?

 

[Malcav]

Ok checked things out a bit more and found that the dll needs to be registered to use sp_oa.
ran regsvr32 x.dll
got the error message
'DLLRegister server entry point not found'
is there any other way to call this dll or register it.

 

[bborissov]

regsvr32 (full path to x.DLL)\x.dll

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[Malcav]

Still no joy with that.
However I have had limited success with addextendedproc
however how do I send parameters to master.dbo.findguy
I tried just 'dud|1111',60 but that gets back the same result as if I dont send anything at all