Re: Best Means: Calling a Function or Application on a Remote Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



On Mar 11, 12:18 pm, Pavel Minaev <int...@xxxxxxxxx> wrote:
On Mar 11, 9:25 am, "jehugalea...@xxxxxxxxx" <jehugalea...@xxxxxxxxx>
wrote:

Hello:

Our users have an application where they can initiate jobs on our
servers. Currently, we have Oracle stored procedures that execute
applications on the database server. We hate using the database this
way.

We would like our applications to be run without needing to initiate
them with a database.

We are currently gathering information on the approaches we can take.
What are some options?

If I understand you correctly, you essentially want to do RPC between
two machines. In that case...

The default one would be a Web service (easiest to write, popular
approach so lots of examples/tutorials, good integrated
security). .NET remoting is another option. Then of course there's COM
+ components and MSMQ.

What would be the most scalable option?

Depends on your scenario, and on how you implement the server side.
All of them are potentially scalable.

How do we authenticate users?

If you're using .NET in a Windows-only environment with a domain, then
integrated Windows authentication seems to be the most logical
solution. Both ASP.NET web services and WCF support it out of the box,
you just need to configure them to do it.

What other security measures do we need to take?

Hard to say without knowing what you do, but you might want to protect
the data that is transmitted from clients to the server. If you use
Web services for that, then you'd just use SSL/TLS.

What needs to be on the machine in order for the code to run?

For any .NET solution - .NET, obviously. Anything else is optional;
with WCF, you can have a self-hosting Web service application, for
example, and .NET remoting has always allowed to embed hosts into .exe

In practice, most people host their Web services in IIS.

Most of our applications need the database SID, user name and password
passed in. How can pass this information securely? (We can always use
Oracle proxy authentication.)

If you use Windows integrated authentication and WCF, you needn't
worry - it will handle it all in a secure way.

If using a web service, can I allow the method to wait indefinitely?
Some of our processes take hours to run. It might not matter in the
long run, but it is good to know. For instance, we might some day want
to asynchronously call a service method and have it indicate
completion.

It would be even more cool if we could raise some sort of events,
where we could regularly update the status of the process. We can
technically do that on the database side, but it would be even cooler
if the service could handle it.
.



Relevant Pages

  • Re: Basic application design
    ... Database is in one country where the internet is excellent. ... If we go for an ASP net based solution, then the server hosting ... Web Service running on ASP.Net. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help - N Tier Architecture ?
    ... So you set up a seperate server to host this assembly (via ... application server and database). ... other words, you could have a stock quote web service, that exclusively does ... >it n - tier architecture very good design. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Web Service using Windows Authentication
    ... domain/login for the server. ... database access to the database your web service is using. ... >this user account in a SQL server, ...
    (microsoft.public.sqlserver.security)
  • Re: Basic application design
    ... Web Service running on ASP.Net. ... the database will be used and updated ... Database is in one country where the internet is excellent. ... If we go for an ASP net based solution, then the server hosting ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Threading within a service
    ... One solution is to increase the timeout value on your proxies to the other ... As for an asynchronous call to the database, ... it calls a webservice on a local server to check what items the ... > success rate on the web service. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)