Oracle DB with Pro/5

[Dominic]

Hi,

I am TOTALLY new to all this stuff and really hope to find help here.

I have to come up with a solution for one of my client.
They use HP-UX and Pro/5

What I'm trying to do:
Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.
What I need to know and do:
- Find an OBDC driver that will allow me to connect to the ORACLE database.
- Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
files important ?? What should they look like ? Have any example of those
file for an Oracle database.

==========================
I just need to install a simple test oracle database and query a table from
pro/5.

All this is so new, my question might seem to much work to explain, but I
read a lot on many website, but can't make things to work ... can't find an
obdc .. don't know how to configure it anyway ... I need help please.

I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
VPRO5) , I just need help of someone who did this already.


Thanks !
Dominic

db*****@cosotech.com

[Peter Murray]

Hi Dominic,

If you have the Oracle CD and have installed Oracle client libraries, an
ODBC driver should come with it. Alternatively, you can download a
driver from DataDirect (http://www.datadirect.com). Their drivers do not
require Oracle's client libraries however these drivers will cost you $500.

You could also try WinSQL (http://www.synametrics.com) that comes with
Oracle's Driver and can be used to test your connectivity.

Regards,
PM

Dominic wrote:

Hi,

I am TOTALLY new to all this stuff and really hope to find help here.

I have to come up with a solution for one of my client.
They use HP-UX and Pro/5

What I'm trying to do:
Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.
What I need to know and do:
- Find an OBDC driver that will allow me to connect to the ORACLE database.
- Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
files important ?? What should they look like ? Have any example of those
file for an Oracle database.

==========================
I just need to install a simple test oracle database and query a table from
pro/5.

All this is so new, my question might seem to much work to explain, but I
read a lot on many website, but can't make things to work ... can't find an
obdc .. don't know how to configure it anyway ... I need help please.

I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
VPRO5) , I just need help of someone who did this already.


Thanks !
Dominic

db*****@cosotech.com