Re: ocilib for MacOSX/9iR2

Kent Brockman <Brockman_at_channelsix.news> wrote in message news:<3DD96489.2030809_at_channelsix.news>...
> Hi,
>
> I have succesfully installed the developer release of oracle 9iR2 on
> MacOSX 10.2 "Jaguar".
>
> I want to use this database from ODBC clients. When looking into one of
> the options for ODBC (from OpenLink) I noticed that their lite driver
> depends on ocilib. According to OpenLink is this a part that is missing
> in the 9i distribution and I should get it from th 8i distribution.
> Problem is: where do I get it?

There are a few possible answers, Eddy.

First, the OpenLink Oracle Lite drivers, both 8 and 9, ship with the necessary base OCI library, libclntsh.dylib. All you need to do is create a directory to be used as ORACLE_HOME, create subdirectories $ORACLE_HOME/network/ and $ORACLE_HOME/network/admin, and touch $ORACLE_HOME/network/admin/tnsnames.ora. Set the privileges on these directories and that file to 775 or 777 (`chmod 777 $ORACLE_HOME/network/admin/tnsnames.ora`), and you're good to go.

The DNS configuration panel for Oracle Lite incudes a TNS Names Editor, which will work with this file, once you specify ORACLE_HOME in that panel.

This installation does not include the complete set of Oracle Client Libraries, so error messages will be of the form `could not find text for ORA-#####`. You can search the web or your Oracle documentation for the meaning of the ORA-##### error, or you can download the complete Oracle Client and configure things slightly differently --

Second answer -- Oracle provides the `Oracle8i OCI driver for Mac OS X` through their OTN site, but they do require that you register with their Developer Network before downloading. It's mis-filed, but you can (as of posting date) access it through this page --

<http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html>

Install these components according to the Oracle instructions, and set the destination directory as ORACLE_HOME in the DSN configuration dialog, as above. The only benefit you get from this installation is full-text Oracle error messages.

> Does anyone know where and how to get this? Either from the Oracle site
> or someplace else.
>
> I need to review the ODBC connection for a project that I am
> negotiating. The customer wants to run oracle on Windows and the clients
> on MacOSX. Without this part I (and I think no-one) can build what the
> customer is asking.

I think the above information should cover your needs. Please feel free to open a support case through the OpenLink website, if you need further information. This is a free service.

Be seeing you,

Ted Thibodeau Jr
Consultant
OpenLink Software, Inc. // <http://www.openlinksw.com/> ODBC, XML & E-Business Infrastructure Technology Providers Received on Mon Dec 16 2002 - 15:55:22 CST