Re: Oracle DB with Pro/5

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
>
> dbelley_at_cosotech.com
>
>
>
>
Received on Fri Jul 23 2004 - 12:30:45 CEST