unixODBC-2.2.14-2 on a 64-bit architecture?

[drimtajm]

Hi guys and girls!

I'm wondering if anyone has successfully used the latest unixODBC package (version 2.2.14-2) on a 64-bit architecture?

I am having trouble with my drivers - the driver manager cannot seem to find them (and yes, I have checked that the lib is there, non-empty and a 64-bit lib) :

[oracle@vierstein ~]$ isql -v OracleODBC-11g
[01000][unixODBC][Driver Manager]Can't open lib
'/usr/local/share/oracle/11g/lib/libsqora.so.11.1' : file not found
[ISQL]ERROR: Could not SQLConnect

Why do I get this error message when I know the file exists?

I am pretty sure my configuration is correct, after some difficulties I have managed to install and start Oracle Database 11g, although the installation program complained about some i386 packages that it couldn't find since I only had found i586 and i686 versions in the F11 repositories. Quick question about this: What is the difference (from Oracle's point of view) between i586 and i686 packages vs i386 packages? They still contain 32-bit libraries, right? And if all dependencies are satisfied, it should work.

Anyway, I have created a new database and I am able to connect to it via sqlplus. I'm not trying to do anything over a network or something, the only thing that could mess things up is that I'm running the 64-bit version of Fedora. I have tried the 32-bit versions of unixODBC + driver but I get the same result. I also tried copying the driver lib to /usr/lib64 and /usr/lib. Furthermore, I tested with a different driver (from easysoft). Still, same result.

So, I'm simply trying to find out if there is something weird with the unixODBC package for F11 preview or if it's just me before reporting any bug.

[MetaCarpal]

Have you set the LD_LIBRARY_PATH variable?

Try this:

export LD_LIBRARY_PATH=/usr/local/share/oracle/11g/lib:/lib64:/usr/lib64:/lib:/usr/lib:$LD_LIBRARY_PATH

Also, did you install the 64-bit oracle package, or the 32-bit? If the 32-bit, you will need the iX86 package (which one makes no difference, i586 should do nicely)

[drimtajm]

Thanks for the suggestion, but I didn't need to set the LD_LIBRARY_PATH since my odbcinst.ini contained the full path to the driver.
Also, when I had downloaded the 32-bit Oracle by mistake, I couldn't install it. (The 64-bit version still requires som 32-bit libs though and comes with a 32-bit odbc driver.)

I have actually found the cause of the problem now (thanks to Nick Gorham who taught me that there's a nifty command called ldd ) : The library libodbcinst.so.1 is missing!

So I guess this is a bug in F11 preview...

[MetaCarpal]

libodbcinst.so.1 is provided by the Oracle Instant Client package/installation. It's not a native Fedora lib.

[drimtajm]

Ok, I will check if I can get hold of that library. It WAS part of the unixODBC package in Fedora 10 but apparently it has been replaced by libodbcinst.so.2 so there seems to be a mismatch between the current driver manager and the current drivers (which are not supplied by Fedora unfortunately).
I guess I'm paying the price for wanting to have the latest software...
So if I cannot find a working libodbcinst.so.1, my best option is to downgrade unixODBC until there is a better driver available.

[drimtajm]

It works now!
What I did: Created a link libodbcinst.so.1 in /usr/lib64 pointing to libodbcinst.so.2

I know, VERY ugly, but if Oracle's software can't keep up with Rawhide, I guess a few tricks are allowed to make things work.
The documentation in the odbc directory was actually from their old database version (10g) !

As long as my setup works, I'm happy.

[drimtajm]

It seems I spoke too soon...
I can connect to the database now, but not use it.
So I will probably downgrade unixODBC.