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

Tacho tachoymu at gmail.com
Thu Jul 15 18:25:22 BST 2010


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


More information about the unixODBC-support mailing list