Oracle DB, Remoting and .NET

[ashehu]

Hi all,
I am workibng on an application that will interact with an Oracle
database and this is the first time I am doin sthg with oracle. From
what I read in other posts, I will have to install the oracle Client
before I can use any of the providers (MS or Oracle) to interact with
the database. I assume this will also be the case for each system that
I will deploy the app to. I want to find another alternative to this
as someone in another thread mention licensing issues and other stuff.
Anyway I am thinking on what the best way of doing this is. My options
are either:
1. Go with installing the client on every machine that will use the
application. (What r the issues with this)
2. Use .NET remoting (which I am new to) to create a middle tier which
will run on a machine that will have the client installed. Other
systems will now communicate with this.
What is the best way to go about it.

Thanks,

Ammar

 

[Glenn]

Hi all,
I am workibng on an application that will interact with an Oracle
database and this is the first time I am doin sthg with oracle. From
what I read in other posts, I will have to install the oracle Client
before I can use any of the providers (MS or Oracle) to interact with
the database. I assume this will also be the case for each system that
I will deploy the app to. I want to find another alternative to this
as someone in another thread mention licensing issues and other stuff.
Anyway I am thinking on what the best way of doing this is. My options
are either:
1. Go with installing the client on every machine that will use the
application. (What r the issues with this)
2. Use .NET remoting (which I am new to) to create a middle tier which
will run on a machine that will have the client installed. Other
systems will now communicate with this.
What is the best way to go about it.

Thanks,

Ammar

Ammar

Although remoting would give you a performance advantage if your using tcp
channel, it's not as easy to do as just using web services to move DataSets
between UI and business/data logic. If you do decide to use remoting you
have to consider that remoting servers run in FullTrust. If you fail to
secure your endpoints you open the app up to subversion. The way round this
in remoting is to use IIS to host the remoting app, or I believe you can
create a custom channel sink to handle security - not done it myself so I
have no idea how easy or difficult it is.

As for licensing, you'll need to read up on what Oracle considers a client.
You may only have the one client install on your middle-tier server but
Oracle may consider each user of that server a client.

One more thing, if the app needs to be available over the Internet then
you're looking at an Oracle enterprise licence which I believe is about
45,000 sterling.

You may also want to take a look at ODP.net. I believe there are
limitations in terms of integration with the DataSet designer in VS, but
this may have been rectified in a later release than the one I use.

HTH

Glenn