I've been rying to get my unixODBC up and running for the last week.<br><br>I'm following some Business Objects official documentation on how to install configure the unixODBC. Due to versioning etc. I'm, never gonna get an exact match between my work and that described step by step in the document.<br>
<br>The first divergence from the process was when I was instructed to <br><br># ./configure --prefix=/tmp/unixODBC --enable-gui=No<br><br>I could not run this statement with the option "--enable-gui=No", likewise it did not work for "--enable-gui=Yes". I had to remove it altogether before being able to run the configure command. I don't know whether this will have much of a bearing further down the track (any obvious foobar's please let me know).<br>
<br>anyway I go on to do the<br># make <br>and<br># make install <br><br>okay then copy my resultant lib filesto the lib folder in the BO lib folder making sure they're still executable (which they are).<br><br>I then install the MySQL connector/ODBC drivers.. Now this is weird. I must've ran the rpm ages ago since when I try and run it again it comes back with 'already installed', <br>
<i>[root@moran bobje]# rpm -i mysql-connector-odbc-5.1.5-0.i386.rpm<br> package mysql-connector-odbc-5.1.5-0 is already installed<br><br></i>which is OK,...However, there should also be a bin and lib folder created in the folder mysql-odbc <br>
<br><i>[root@moran mysql-odbc]# ls<br>ChangeLog INSTALL LICENSE.exceptions LICENSE.gpl README README.debug</i><br><br>It's these libs that should have been created here that I should be pointing my Driver at in my odbc.ini file.<br>
<br><br>MORE INFO : (may have a bearing - Let me know if I can clarify it for you further - THANKS! <br>
<br><br>
libmyodbc5.so was the latest .so file created during the make, and no
'libmyodbc3_r.so' was created during the make of the
unixODBC-2.2.14.tar.gz file<br>
<br>
Here's what was created and copied to this lib folder :<br>
[eberwick@moran lib]$ ls -l<br>
total 9056<br>
-rwxr-xr-x 1 eberwick eberwick 6584012 Aug 18 18:25 <a href="http://libmyodbc3S-5.1.5.so">libmyodbc3S-5.1.5.so</a><br>
-rwxr-xr-x 1 eberwick eberwick 1136 Aug 18 18:25 libmyodbc3S.la<br>
<b>lrwxrwxrwx 1 eberwick eberwick 20 Jan 9 15:00 libmyodbc3S.so
-> <a href="http://libmyodbc3S-5.1.5.so">libmyodbc3S-5.1.5.so</a></b><br>
-rwxr-xr-x 1 eberwick eberwick 2658805 Aug 18 18:25 <a href="http://libmyodbc5-5.1.5.so">libmyodbc5-5.1.5.so</a><br>
-rwxr-xr-x 1 eberwick eberwick 1046 Aug 18 18:25 <a href="http://libmyodbc5.la">libmyodbc5.la</a><br>
<b>lrwxrwxrwx 1 eberwick eberwick 19 Jan 9 15:00 libmyodbc5.so ->
<a href="http://libmyodbc5-5.1.5.so">libmyodbc5-5.1.5.so</a></b><br>
<br>
<i>...from my odbc.ini file<br>
<br>
[ODBC Data Sources]<br>
CRSQLServerWP=DataDirect 5.3 SQLServer Wire Protocol Driver<br>
CRSybaseWP=DataDirect 5.3 Sybase Wire Protocol Driver<br>
CRText=DataDirect 5.3 Text Driver<br>
BOE120_AUDIT=auditor<br>
%SYBASEDSN%=DataDirect 5.3 Sybase Wire Protocol Driver<br>
<br>
[BOE120_AUDIT]<br>
<b>Driver=/home/eberwick/Desktop/bobje/mysql-odbc</b></i>/lib/libmyodbc5.so<span style="color: rgb(255, 0, 0);"> (I'll try and copy it here anyway and see does it work)</span><i><br>
Description=auditor<br>
SERVER=<a href="http://moran.anam.com">moran.anam.com</a><br>
PORT=3306<br>
USER=Administrator<br>
Password=<br>
Database=BOE120_AUDIT<br>
OPTION=3<br>
SOCKET=<br>
Trace=off<br>
stmt=SET CHARACTER SET utf8<br>
</i><br>