Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2009-11

sqldb, oracle, and mac os x

2 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Bee Jay

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).

Any hints? TIA.

-Bee- ...making buzzes at http://twitter.com/beezing ...writing stories at http://beeography.wordpress.com

Reply by email

Michael Van Canneyt
to Bee Jay
Bee Jay wrote 18 lines
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.

Reply by email