2] Also, you might have a permissions issue. Try setting permissions for the Oracle directory to "admin" (and then I upgrade my witango "user" to admin as well)
3] And last but not least, if you don't have a Unix "alias" correctly set up for Oracle OCI, you'll get the error you described.
If you already have a /Library/Frameworks/OracleOCI directory, fine
Delete the "old" alias
Otherwise, create folders as needed to create these
Open the terminal window
type in
sudo ln -s /Library/Application\ Support/Oracle/Home/8.1.7.1/lib/libclntsh.dylib /Library/Frameworks/OracleOCI/OracleOCI
changing the "address" for the libclntsh.dylib to match what you have. (The easiest way to do this is to:
type sudo ln -s (being sure to leave a space after the -s) and then drag the icon for the libclntsh.dylib over the terminal window - it will put in the correct address.
On Thursday, May 29, 2003, at 02:10 PM, Dominique Demore wrote:
Hello everyone.
For that last couple of weeks I have been trying to get the Oracle OCI
working with the Dev Studio and the App Server on OS X. I am wondering if
anyone has had any luck with this. If so, would you be kind enough to
provide me with some instructions.
This is what I have tried so far:
- Followed the instrcution that came with the Server ( pdf file ).
- Tried the production and preview version of the App server and Dev
Studio. ( I did notice the thread about version 058 of the App server).
- Tried a new install on another OS X workstation, thinking maybe I missed
something.
- Reinstalled the OCI drivers from Oracle.
- created an environment.plist to set the variables.
- Manually entered the variables.
In the Dev Studio, I get the option to create a new "Oracle" datasource,
but when I try to connected it says: "Unable to connect to the datasource
<datasource name>. Verify that the data source is properly configured and
that the database server is online."
If I use the openlink Oracle connector, it works, but I would like to use
the native Oracle feature instead.
Oracle box information: AlphaVMS 7.2-1
Oracle 8.1.7.0
Witango Server: Xserve running 10.2.6
Workstation: running 10.2.6
Any thoughts, suggestions, comments on when I may go from here?
Thanks,
-----
Dominique D�mor�
Technical Services Coordinator
Rainbow District School Board
69 Young Street
Sudbury, Ontario
P3E 3G5
Tel: (705) 674-3171 x. 258
Fax: (705) 671-2442
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
