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

[Tacho]

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
>