TOracleConnection and libociei.so

[jdredd]

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]

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

[jdredd]

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]

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]

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.

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]

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]

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.