TOracleConnection and libociei.so
lazarus / 16-Databases

----------------------------------------------------------------------
jdredd · 2011-01-15 16:23

Finally set up an ubunutu machine.  I have perl, python, and php all
installed and working with oracle connections.

The way i took it from some other threads i found out there, that
Lazarus doesn't use the env variables. So must mean i have to setup
somewhere to tell it where to look for these files?

when I do locate on this file it points to

/usr/lib/oracle/11.2/client/lib/libociei.so

Just guess i need to know where in fpc/lazarus/whatever to tell it
where to look at.

----------------------------------------------------------------------
jdredd · 2011-01-20 16:29

been messing with this off and on, and still can't figure out what I
am doing wrong.

----------------------------------------------------------------------
jdredd · 2011-01-21 22:26

still can't seem to get this to work at all... every other language
works with oracle but lazarus/fpc ... and can't seem to find anywhere
on what I am missing on doing.

----------------------------------------------------------------------
ik · 2011-01-22 08:56

You need to add the library path to /etc/ld.so.conf.d/ and then run
ldconfig with sudo.

That way, the system will find the library and so does the linker for
your program.

----------------------------------------------------------------------
jdredd · 2011-01-25 01:51

Quote from: ik on January 22, 2011, 09:56:50 amYou need to add the
library path to /etc/ld.so.conf.d/ and then run ldconfig with sudo.

That way, the system will find the library and so does the linker for
your program.

thanks... i tried this, but still not working.

verified it with ldconfig -v

/usr/lib/oracle/11.2/client/lib:
        libocci.so.11.1 -> libocci.so.11.1
        libociei.so -> libociei.so
        libsqlplusic.so -> libsqlplusic.so
        libocijdbc11.so -> libocijdbc11.so
        libclntsh.so.11.1 -> libclntsh.so.11.1
        libnnz11.so -> libnnz11.so
        libsqlplus.so -> libsqlplus.so

----------------------------------------------------------------------
jdredd · 2011-01-25 05:47

ik - thanks got it finally working!

Issue was I was downloading the 11.x oracle client stuff, looks like I
needed 10.x

Unzipped packages to a folder did the ldconfig stuff and now it works
fine.

----------------------------------------------------------------------
jdredd · 2011-01-25 06:43

spoke to soon...

SqlDB connects to the oracle db ... no errors finally..

But can't get anything else working.

Wrote simple query ... and it yelled about not have a transaction?

anded one... but then I get ORA errors after that.

Not as easy to use as ODAC

I wasn't able to get ZeosLib to connect at all. Can't get the settings
right for whatever reason. But i don't get library missing errors
anymore.