Re: Help:Accessing databases on Unix

"icety" <guess_at_what.com> wrote in message news:<ae4d4o$43g$1_at_ih292.ea.unisys.com>...
> Hi
>
> Please help with newbie question. We want to install an oracle database on a
> Unix server and the application to manipulate on Windows platform.
>
> The question is, do we need any special OBDC drivers for Windows in order to
> access Oracle on Unix?
> or
> Are the any setting/ drivers from Unix Oracle that will allow windows
> application to communicate with it?
>
> Thanks for reading these questions and respodning
>
> Regards
> IceTy

I don't know what Oracle version you are using but here is a quick rundown if you are using version 8.x.x.

Install Oracle server components first and then create your database. If you are just practicing...you can let the system create a starter database for you. You can then use Net8 Configuration assistant to setup your listener file on the server to listen for incoming connections.

Now install your client on Win9x/NT/2K platforms. Installer will install all the necessary components for you to communicate with an Oracle instance. To setup connection parameters to connect to your new starter database, you can again run Net8 Configuration assistant and configure your connection. Make sure you can ping the server from client and have necessary protocols e.g. TCP/IP installed.

Since versions 8.x and up...Oracle has all the GUI tools to setup your Database, Client configuration etc...however, all of them running seamlessly is another matter. Received on Tue Jun 11 2002 - 11:30:20 CDT