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
KerryHi 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.
Cheers,
Kerry
June 15, 2007, 09:23 AM
jgelonaBack 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