Hi,
I have BOXI 3.1 running on RHEL 5.0. Im trying to set up unix ODBC so as to connect to our MySQL data sources.
I used the SAP BO document
which details this procedure for BOXI Release 2. There is no equivalent for 3.1.
Anyway following this to the letter
ASIDE : Page 2 - BTW the command
./configure --prefix=/tmp/unixODBC --enable-gui=No
needs to be edited to
./configure --prefix=/tmp/unixODBC --enable-gui=no
I get to the section on page 4.
Add a data source entry for auditor for example : boe115_audit
I add one for the name of of my CMS database name but don't know the name of the driver I put this equal to here. Is it unixODBC or mysql-connector-odbc Driver. For example by default the odbc.ini is populated with these ODBC Data Sources.
ODBC Data Sources
CRSQLServerWP=DataDirect 5.3 SQLServer Wire Protocol Driver
CRSybaseWP=DataDirect 5.3 Sybase Wire Protocol Driver
CRText=DataDirect 5.3 Text Driver
%SYBASEDSN%=DataDirect 5.3 Sybase Wire Protocol Driver
I then populate the connection parameters. As per below
ODBC Data Sources
..
.
BOE120_AUDIT=mysql-connector-odbc Driver ???
BOE120_AUDIT
Driver=/home/BOXI/mysql-odbc/lib/libmyodbc3_r.so
Description=auditor
SERVER=mulligan
PORT=3306
USER=telus
Password=maple
Database=BOE120_AUDIT
OPTION=3
SOCKET=
Trace=off
stmt=SET CHARACTER SET utf8
I then configure the environment
#env
gives me
..
ODBCINI=/home/BOXI/bobje/odbc.ini
..
as directed
Now to test the connection
Inputting
root@tmp/unixODBC/bin isql - v BOE120_AUDIT
gives me nada - I check and sure enough there is no
libmyodbc3_r.so in the dir
/home/BOXI/mysql-odbc/lib
just those
root@mulligan lib# ls
libmyodbc3S-5.1.5.so libmyodbc3S.la libmyodbc3S.so libmyodbc5-5.1.5.so libmyodbc5.la libmyodbc5.so
I go back and edit odbc.ini with each of the .so files available in my lib folder. I presume my later version of mysql-connector-odbc no longer creates libmyodbc3_r.so.
None of them work, see various error messages below.
What would you suggest I do? would it be advisable to source the older version of mysql-connector-odbc binaries since these new ones don't work? Any pointers welcome.
libmyodbc3S-5.1.5.so (tried)
root@mulligan bin# ./isql -v BOE120_AUDIT
IM004unixODBCDriver ManagerDriver's SQLAllocHandle on SQL_HANDLE_HENV failed
ISQLERROR: Could not SQLConnect
libmyodbc5-5.1.5.so (tried)
root@mulligan bin# ./isql -v BOE120_AUDIT
Segmentation fault
libmyodbc3S.la (not tried since not .so files)
libmyodbc5.la (not tried)
libmyodbc3S.so (tried)
root@mulligan bin# ./isql -v BOE120_AUDIT
IM004unixODBCDriver ManagerDriver's SQLAllocHandle on SQL_HANDLE_HENV failed
ISQLERROR: Could not SQLConnect
libmyodbc5.so (tried)
root@mulligan bin# ./isql -v BOE120_AUDIT
Segmentation fault