Urgent - Access to DB based on Digital Unix

[Marion]

Hello,

I need to find a solution to create an application whitch access an oracle 8 database, based on a Digital Unix Server.
Any type of application is ok: Standard Client-Server, Web ...

But it seems access to this kind of server is quite complicated. If you have any info..


Thanks

 

[MikeLacey]

Marion,

There are a number of ways to connect to an Oracle database running on another machine.

The first thing you have to do is install the Oracle client on the machine which will run the application. Part of that process asks you to define which databases you will connect to. It will ask you for an alias for the remote database (pick any name), the hostname or IP address of the database server (ask your DBA), the protocol (TCP usually nowadays), and the name of the database on the database server (ask your DBA again)

If you can sucessfully run tnsping db_alias, where db_alias is the alias for the remote database you defined above, then the client installation is ok.

Make sure you get the client installation running, without error, first.

The next step is a biggie:

[tab]What do you want to do?

[tab]What language do you want to write your application in?

[tab]What do you have available to you?

There are a number of alternatives: Visual Basic, Perl, C, C++, PL/SQL --- the list is pretty much endless. Ask around the office/where-ever and see if you can fit in with something that someone else is doing; it will make your task (and maybe theirs) a lot easier if you can.

Come back to us when you've done some digging or if you have troubles configuring the Oracle client. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.