MBS Xojo Developer Conference and Training
Join us from 3rd to 6th May 2017 in Berlin, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

FAQ.How to avoid trouble connecting to oracle database with SQL Plugin?
Feedback.

Answer: For oracle the most important thing is to point the plugin to the libraries from oracle.
Notes:
In environment variables, the paths like ORACLE_HOME must be defined.
On Mac OS X you also need to define DYLD_LIBRARY_PATH to point to the dylib files from oracle.

For that you need to modify /etc/launchd.conf for Mac OS X 10.8 and newer.
In older versions those variables in .MacOSX/environment.plist file in user's home.

Another way for the case you bundle things inside your app is to use the LSEnvironment key in info.plist.
In info.plist it looks like this:

<key>LSEnvironment</key>
<dict>
<key>test</key>
<string>Hello World</string>
</dict>




Links
MBS FileMaker blog