BBX - PRO/5 --> Oracle Database

[CosoGuy]

Hi,

I would like some hints regarding my problem:
( I am very beginner with all this Unix-BBX-Pro/5 stuff )

In a PRO/5 application, I need to make SQL requests (SELECT) to a Unix - Oracle database.

I need to know all it implies.
- Establish the connection to the database
- Execute the SQL statement ( this I can figure out )
===============
Thanks for any hint, advise, help, code snippet, source links you can give me.

 

[CosoGuy]

I have made some progress. But still far from my goal.

I need to know where to find driver for MS Access and Oracle for Unix.

I need to have example of OBDC.ini and SQL.ini file to see more concrete configuration examples.

 

[ecobb]

If you have the Oracle Client tools you can use them to log on and query the database directly. They should be on the Oracle CD.



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[CosoGuy]

I need to learn how to establish the connection to Oracle and query a table from my PRO/5 application.

I don't know client tools on Unix. But on Windows environnement its a visual tools to connect to database and make queries. That is not what I want to do. Using the client tools won't help me. Querying the table is not my main issue. I need to know how to establish a connection to Oracle from a bbx(pro/5) application by coding.