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

Neha Avasthy neha.avasthy at gmail.com
Tue Jul 26 03:57:29 BST 2011


Hi Jeff,

Can you check the file type of
/export/home/jmartin/oracle-InstantClient-11.2.0.2/libsqora.so.11.1 . Also
do an ldd to check for dependencies (if any)

-Neha

On Tue, Jul 26, 2011 at 6:02 AM, Jeff Martin <JMartin at telecomsys.com> 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:****
>
> ** **
>
> [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.
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110726/56749110/attachment.html>


More information about the unixODBC-support mailing list