At 10:43 15.10.99 +1300, Mike Humphreys (DSL Ch) wrote:
>Does anyone out there have any experience or knowledge of writing programmes
>that access an Oracle database that is hosted on a SunOS 5.5 Host from
>Linux?
Yes, I've done something very similar (remote oracle DB on NT).
I think the best way to get startet would be by downloading the oracle
workgroup server for linux; this contains the needed oracle sqlnet client
libraries and sample code for OCI (Oracle Call Interface) applications (in
$ORACLE_HOME/rdbms/demo).
For your programs you can either use the OCI interface (fairly lowlevel,
very powerfull, fast) or you could use pro*c, a c- language preprocessor
which converts embedded sql commands to OCI syntax. Easier to use but not
quite as efficient as doing OCI yourself, used to requiere a seperate
license (not sure about current status).
You'll probably want to look at the OCI and Pro*C Documentation, wich are
available at http://technet.oracle.com/docs/products/oracle8/doc_index.htm
(needs a free technet registration).
Bye, Martin
"you have moved your mouse, please reboot to make this change take effect"
--------------------------------------------------
Martin Bene vox: +43-664-3251047
simon media fax: +43-316-813824-6
Andreas-Hofer-Platz 9 e-mail: [EMAIL PROTECTED]
8010 Graz, Austria
--------------------------------------------------
finger [EMAIL PROTECTED] for PGP public key
