Hi everbody,<br><br>I'm having problems trying to connecto from Oracle to MS SQL Server, once the unixODBC and freeTDS has been installed, configured and tested successfully.<br>But when I want to make a connection from SQL*plus using a select statement the following error is issued:<br>
<br><b>Failed to load ODBC library symbol: /usr/local/lib/libodbc.so.1(SQLAllocHandle)<br></b><br>I have been working with Oracle Support and they determined that the problem is that libodbc.so.1 is 32bit version.<br><br>
My Oracle software is 64bit as well as the dg4odbc, as we can see below:<br><br><span style="font-family: courier new,monospace;"># file $ORACLE_HOME/bin/oracle</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">oracle: 64-bit XCOFF executable or object module not stripped</span><br>
<br><span style="font-family: courier new,monospace;"># file $ORACLE_HOME/bin/dg4odbc</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">dg4odbc: 64-bit XCOFF executable or object module not stripped</span><br>
<br>but when the file command is used in libodbc.so.1, it is not showing a 64bit version, it is saying that is 32bit:<br><br><span style="font-family: courier new,monospace;">file /usr/local/lib/libodbc.so.1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">/usr/local/lib/libodbc.so.1: executable (RISC System/6000) or object module not stripped</span><br><br>By default, if a version is not shown when file command is run, then the executable is 32bit (according to 225551.1 doc )<br>
<br>Here is a list telling if 32bit or 64bit is installed on my server:<br><br><b>APLICATION</b><br>see above (oracle and dg4odbc executables)<br><br><b>KERNEL</b><br><span style="font-family: courier new,monospace;">ls -l /unix</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">lrwxrwxrwx 1 root system 21 Feb 05 2009 /unix -> /usr/lib/boot/unix_64</span><br><br><b>HARDWARE</b><br><br><span style="font-family: courier new,monospace;"># getconf HARDWARE_BITMODE</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">64</span><br><br><b>KERNEL</b><br><span style="font-family: courier new,monospace;"># getconf KERNEL_BITMODE</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">64</span><br>
<br><b>OPERATING SYSTEM</b><br><span style="font-family: courier new,monospace;">lslpp -l bos.64bit</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Fileset Level State Description </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> ----------------------------------------------------------------------------</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Path: /usr/lib/objrepos</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> bos.64bit 5.3.9.0 COMMITTED Base Operating System 64 bit</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Runtime </span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Path: /etc/objrepos</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> bos.64bit 5.3.9.0 COMMITTED Base Operating System 64 bit</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> Runtime </span><br><br><br>Please need your help to build unixODBC into a 64bit version.<br><br>Thanks in advance.<br><br>
Tacho.<br><br><br>