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

[Tacho]

hsodbc:

regatta[/u03/app/oracle/product/11.1.0/bin]> file -c dg4odbc | grep -i 64-bit
  0      0    1      0 ffffffff      1f7  64-bit XCOFF executable or
object module
  0      0    1      0 ffffffff      1ef  Discontinued 64-bit XCOFF
executable or object module
  0      0    2      0 ffffffff eeeeeeeb  RISC System/6000 64-bit system dump
  0      0    2      0 ffffffff eeeeeeed  RISC System/6000 64-bit system dump
  0    512    2      0 ffffffff eeeeeeeb  RISC System/6000 64-bit system dump
  0    512    2      0 ffffffff eeeeeeed  RISC System/6000 64-bit system dump
  1      4    0      0 ffffffff        2  64-bit

regards.

2010/7/15 Tacho <tachoymu at gmail.com>:
> regatta-NEW-[/usr/local/lib/odbcdir]> file -c libodbc.so.1 | grep -i 64-bit
>  0      0    1      0 ffffffff      1f7  64-bit XCOFF executable or
> object module
>  0      0    1      0 ffffffff      1ef  Discontinued 64-bit XCOFF
> executable or object module
>  0      0    2      0 ffffffff eeeeeeeb  RISC System/6000 64-bit system dump
>  0      0    2      0 ffffffff eeeeeeed  RISC System/6000 64-bit system dump
>  0    512    2      0 ffffffff eeeeeeeb  RISC System/6000 64-bit system dump
>  0    512    2      0 ffffffff eeeeeeed  RISC System/6000 64-bit system dump
>  1      4    0      0 ffffffff        2  64-bit
>
>
> 2010/7/15 Tacho <tachoymu at gmail.com>:
>> Nick , how can I check on AIX unix if it is 64 or 32?
>>
>> 2010/7/15 Nick Gorham <nick.gorham at easysoft.com>:
>>> 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
>>> _______________________________________________
>>> unixODBC-support mailing list
>>> unixODBC-support at mailman.unixodbc.org
>>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>>>
>>
>