[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
"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


Driver =

ServerName = oradb1:1521/Orcl


% ls -l

-rwxrwxr-x   1 jmartin  developr  748520 Sep 13  2010


% isql -v ora11

[01000][unixODBC][Driver Manager]Can't open lib
'/export/home/jmartin/oracle-InstantClient-' :
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:




                        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-' :
file not found


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


-- 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