Skip to Content
0
Former Member
Feb 18, 2009 at 03:00 PM

unixODBC - mysql connector odbc test - not working

266 Views

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

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20e11153-5c3f-2b10-f9be-974dc4749fd8

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