On Thu, 26 Nov 2009, Bee Jay wrote:
Hi all,
I'm writing a program which connects to a remote Oracle server using sqlDB
(TOracleConnection). TOracleConnection keeps telling me that Oracle client
library (libociei.dylib) is not yet installed. However, I'm pretty sure that
it's already installed correctly since Oracle's SQLPlus is already able to
connect to the remote database server.
I installed Oracle's Instant Client Basic Package and SQL*Plus Package from
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html
using the 32 bit version (I'm on Leopard Intel). Set the required symlinks
and environment variables (ORACLE_HOME, DYLD_LIBRARY_PATH, SQL_PATH) within
/etc/profile, .bash_login, and environment.plist. Testing the installation
using SQLPlus showed that SQLPlus is able to connect to an Oracle database.
I'm using FPC v.2.2.4 and Lazarus 9.29. This is my first experience accessing
Oracle from Mac OS. I never had this kind of problem while on Linux (Ubuntu
and CentOS).
Do you know where the lazarus program looks for the library ? The oracle
support in sqlDB doesn't honor any of the variables you mention, so I
suspect that you should copy libociei.dylib from one of the oracle
directories to your program directory.
Michael.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
