Focal Point
how to connect to an oracle db from Focus 6.9.3

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1791044032

May 31, 2007, 05:06 PM
<kasha>
how to connect to an oracle db from Focus 6.9.3
Hi All,

Can any one direct me to or send me a primer or documentation on how to connect to an oracle db from Focus 6.9.3.?

Thanks,
June 14, 2007, 03:59 PM
Kerry
Hi kasha,

I am checking with internal people on this one. Can you please let us know what platform you are on? For UNIX, FOCUS versions are 6/85, 6/92 and 6/94, no 6/93.

Thank you in advance for clarifying and sharing with all. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
June 15, 2007, 09:23 AM
jgelona
Back when we were using FOCUS for HP/UX, this was the connect statement we used where ora_userid was a valid oracle user id and 'password' was that password for the oracle user. KIDS was the name of the entry in the tnsnames.ora file for the database.

!sqlora CONNECT USER ora_userid PASSWORD password
SERVER KIDS
HOME /opt/oracle
END
-RUN


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.