[unixODBC-support] unixODBC can't find Oracle 11 ODBC Driver file, even though it exists (Solaris 10 x86 )

Nick Gorham nick at lurcher.org
Tue Jul 26 01:55:45 BST 2011


On 26/07/2011 01:32, Jeff Martin wrote:
>
> We are trying to use unixODBC on Solaris 10 x86 with 32-bit Oracle 11 
> "instant client drivers".  We downloaded unixODBC 2.3.0 sources and 
> compiled on a Solaris 10 x86 box.  We downloaded the Oracle 11.2.0.2 
> "instant client drivers" for 32-bit Solaris 10 x86, from 
> http://www.oracle.com/technetwork/topics/solx86soft-092689.html.  When 
> I try to run isql, the driver manager errors with "file not found" for 
> the Oracle ODBC driver, even though that file exists:
>
> #---- begin example
>
> % cat $HOME/.odbc.ini
>
> [*ora11*]
>
> Driver = 
> */export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1*
>
> ServerName = oradb1:1521/Orcl
>
> % ls -l 
> */export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1*
>
> *-rwxrwxr-x *1 jmartin  developr *748520* Sep 13  2010 
> /export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1
>
> % isql -v *ora11*
>
> [01000][unixODBC][Driver Manager]*Can't open lib* 
> '*/export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1*' : 
> *file not found*
>
> [ISQL]*ERROR: Could not SQLConnect*
>
> #---- end example
>
> Why does unixODBC driver manager complain "file not found" for a file 
> that clearly exists?  I turned on tracing for unixODBC, but it doesn't 
> shed any more light.  I've attached the complete trace output as 
> unixodbc.trace.  The relevant part is:
>

Most likely its missing a file that the driver needs.

Try

ldd /export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1

And see if there is anything missing.

-- 
Nick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110726/9c078ebe/attachment.html>


More information about the unixODBC-support mailing list