Using an ActiveX component on another machine

[790213]

Does anyone know how I can use the functionality of an ActiveX component on another machine from a stored procedure? I want the component to run on that other machine and not on the database server.

 

[eramgarden]

maybe "linked server"..search for that.

 

[SemperFiDownUnda]

The easiest way might be to create a DTS job with an ActiveX Step and kick it off.

SQL server does not provide a mechanism to access COM objects directly as I know it. You could right an extended stored procedure (normall DLL) that accesses your COM object but that is a little bit harder as you'll need to know C++ and COM in C++.

 

[790213]

There is a way to access com objects via the sp_OA procedures. It's not too hard, but the components I want to use is sitting on a web server and I won't be allowed to install those on the database server. This is where the problem comes in.

If anyone has an idea then please let me know.