Running code on server side

[harjeen]

I'm developing an ActiveX application that clients can access via the web. Is it possible to store several methods in an ActiveX EXE or DLL on the server-side, so that when my application is installed on a client machine, this portion of code always runs on the server?

Thanks in advance for the response,

Nahid Harjee

[lenin]

Hi Hrrjeen,
yes, what you describe ( If I am interpreting you properly ) is building COM componenets. i.e. The source for the methods reside on your machine, and the client calls methods for execution.

There are numerous examples of this on the web.


hth

Lenin

[harjeen]

Yeah, I've been looking at examples of using DCOM/MTS to accomplish this task, however they seem very like very complicated means of simply calling remote methods.

I'm still relatively new to VB as well, so I was hoping for something simpler.

Any other ideas?

[harjeen]

I've also heard it's possible to have SQL Server stored procedures run code stored in an ActiveX EXE/DLL. Can this be done? Does anyone know how?

[Clunietp]

calling MTS components is no different than calling local COM components....that is the beauty of COM/DCOM, it is location independant. You must know how to design and deploy MTS apps though...

look into the sp_OACreate and the other sp_OAxxx methods to manipulate COM objects from SQL Server

Good Luck

Tom

[harjeen]

Thanks a lot Clunietp! I'll try that out.

Nahid