[unixODBC-support] Failed to load ODBC library symbol: /usr/local/libodbc.so.1(SQLAllocHandle)

[Nick Gorham]

Tacho wrote:
> Hi Nick,
>
> I changed the location as you suggested, but the error remains the same:
>
> I did two changes in the $ORACLE_HOME/hs/admin/initsqlserver.ora file,
> in the parameter HS_FDS_SHAREABLE_NAME as follows:
> Firstly, changed to /usr/local/lib/libodbc.so, run select from
> SQL*Plus and error is issued:
> HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so"
> Entered hgolofns at 2010/07/15-10:19:56
>  hoaerr:28500
> Exiting hgolofns at 2010/07/15-10:19:56
> Failed to load ODBC library symbol: /usr/local/lib/libodbc.so(SQLAllocHandle)
>
> Secondly, changed to /usr/local/lib/libodbc.so.1, run select from
> SQL*Plus and error is issued again
> HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so.1"
> Entered hgolofns at 2010/07/15-10:19:58
>  hoaerr:28500
> Exiting hgolofns at 2010/07/15-10:19:58
> Failed to load ODBC library symbol: /usr/local/lib/libodbc.so.1(SQLAllocHandle)
>
> by looking at the contents into the /usr/local/lib directory, we see
> the following libodbc* files:
>
> regatta-[/usr/local/lib]> ls -l libodbc.*
> -rwxr-xr-x    1 root     system      3595747 Jul 12 18:11 libodbc.a
> -rwxr-xr-x    1 root     system          931 Jul 12 18:11 libodbc.la
> -rwxr-xr-x    1 root     system      3578122 Jul 13 18:10 libodbc.so.1
>
> the library libodbc.so does not exist as should be. Does the
> libodbc.so.1  library work the same as libodbc.so does?
>   
I would check they are both the same bit length, ie, the driver manager 
32 bit as so is hsodbc, or both 64 bit.

-- 
Nick