Jump to content


Photo
- - - - -

How to Connect Pro-IV to Oracle Database


2 replies to this topic

#1 Geoff Riley

Geoff Riley

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 17 November 2009 - 02:37 PM

Hi

We are currently using PRO 6.2 and are looking to migrate to Oracle 10g from pro-isam/cisam.

We have pro-iv running on a linux ES5 server and a Oracle database running on a Linux server.

To test connectivity we have created a dummy file in PRO with 1 key and 1 alpha field and also created an equivalent table in Oracle. My question is, how do you set up your connection string between pro-iv and the Oracle DB and are there any on-line user manuals?

If it's easier to connect to Oracle running on windows we can do this instead as a starting point.

Cheers Geoff

#2 Richard Bassett

Richard Bassett

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 696 posts
  • Location:Rural France

Posted 17 November 2009 - 06:48 PM

Geoff,

I assume from what you say that the Oracle DB is on a different Linux box than ProIV.

If so, you need to configure things so that ProIV as the "Oracle client" can find the Oracle "service" (the database) on the other box.

There's more than one way to go about this but, keeping it simple, if I recall correctly you need to worrry about the following:

Configuring the service and running the Oracle listener on the database box (probably done by default).
Installing the Oracle client-side stuff on your ProIV box (I imagine you have already if an Oracle-capable ProIV is working).
Configuring the servicename on the ProIV machine side (just a tnsnames.ora file in the simple case I think - Google it).

The historical Oracle connection string is of the form dbusername/password@servicename

You should be able to test connecting just by using SQL*Plus (or other interactive SQL tool) before trying with ProIV (this is a good idea anyway for sanity checking..)

In the simplest case I think the connect info can be set for ProIV with the following ProIV unix environment variables:

export SQL_USERNAME=dbusername
export SQL_PASSWORD=password@servicename

Good luck. If no one there has used Oracle before you're on a steep learning curve :)
Nothing's as simple as you think

#3 Geoff Riley

Geoff Riley

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 19 November 2009 - 03:18 PM

Thanks Richard.

We've got the service working so can talk to the SQL database via SQL PLUS, now the simple bit of getting Pro-IV to talk to it as well ;-)



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users