Re: Portable code

OK, I'll give it a bite...

If you don't want to install anything (except maybe a browser) on the clients, you could do everything on the server side using OAS/WebDB/CGI/Servlets/etc.

If you don't want to do anything on the server, you'll need your application (correct binaries) and the Oracle client side libraries on the clients. You can use Pro-C or OCI; either case needs the client libraries.

You can also get ODBC libraries for writing ODBC clients on Unix, although it is not supported as strongly as on the PC. You typically need ODBC plus the Oracle client libraries for this (NT or Unix client side). This has the advantage of being portable to other databases, as long as you don't get fancy.

Another option would be to use Java on the client. You would then need the Java Runtime plus Oracle's Thin JDBC driver (or OCI driver + client libs) on the client. This has the advantage of not requiring separate binaries for your application.

A similar twist would be to use an applet, which could be loaded from a Java enabled Browser. This would only require the browser on the client, but would suffer some time to download the applet and JDBC.

If you start looking at 3/N-tier, you could probably mix things up further...

Peter

Jim Tench wrote:
>
> Ok, I'm replying to this myself as I haven't had a reply from the group yet.
> Is this question too difficult or too easy to answer?. If it's too
> difficult then your best guess would be good enough for me, otherwise,
> please feel free to humour an idiot.
>
> Jim
>
> Jim Tench <jim_tench_at_spam.me.baby> wrote in message
> news:936572985.10968.0.nnrp-09.c1ed5616_at_news.demon.co.uk...
> > I want to access an oracle database from C on both NT and UNIX from both
> NT
> > and UNIX, I think this probably excludes ODBC. Any suggestion as to what
> I
> > could use. Is OCI a viable option or do I have to go down the ProC
> route?.
> > Did I mention that I want to avoid the need to install any client software
> > on the host/target?, well I do......
> >
> >
> > Cheers chaps and chapettes.
> >
> >
Received on Thu Sep 09 1999 - 16:58:07 CDT