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

Jeff Martin JMartin at telecomsys.com
Tue Jul 26 01:32:20 BST 2011


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:

 

[ODBC][11343][1311638282.713711][SQLConnect.c][3654]

                Entry:

                        Connection = 806b750

                        Server Name = [ora11][length = 5 (SQL_NTS)]

                        User Name = [NULL]

                        Authentication = [NULL]

[ODBC][11343][1311638282.715725][SQLConnect.c][1106]Can't open lib
'/export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1' :
file not found

 

Does anyone have advice on where to go next to troubleshoot this
problem?

 

-- Jeff

 

 

 

 

 

 

 

 


CONFIDENTIALITY NOTICE: The information contained in this message may be privileged and/or confidential. If you are not the intended recipient, or responsible for delivering this message to the intended recipient, any review, forwarding, dissemination, distribution or copying of this communication or any attachment(s) is strictly prohibited. If you have received this message in error, please notify the sender immediately, and delete it and all attachments from your computer and network.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110725/cf511504/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unixodbc.trace
Type: application/octet-stream
Size: 1948 bytes
Desc: unixodbc.trace
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110725/cf511504/attachment.obj>


More information about the unixODBC-support mailing list