Skip to Content
0
Former Member
Jan 13, 2009 at 04:58 PM

unixODBC not connected

119 Views

Hi there,

I try to schedule report to inbox in CMC and I get the error message

Error Message: A database error occured. The database error text is: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. (WIS 10901)

Where can I specify the default? Must I only edit the odbc.ini file or must I also edit the .profile (bashrc file in my case).

I'm running MYSQL, Red Hat Enterprise Linux 5 and BOXI 3.1.

Below is the odbc.ini I've edited according to the Bus Obj's published document

"How to configure an ODBC connection to MySQL database on Linux / UNIX"

Just wondering though as this doco was created for R2 and there's no equivalent for 3.1 then do I need to install the unixODBC at all?

Any suggestions on how I can edit my odbc.ini (see below) to get the connection up and running - much appreciated.

Thanks

More Detail

A a bit more info on the ODBC file which may assist, the only way it differs from the BO documentation is

libmyodbc5.so was the latest .so file created, no 'libmyodbc3_r.so', was created during the make of the unixODBC-2.2.14.tar.gz file

Here's what was created and copied to this lib folder :

[eberwick@moran lib]$ ls -l

libmyodbc3S-5.1.5.so

libmyodbc3S.la

libmyodbc3S.so

libmyodbc3S-5.1.5.so

libmyodbc5-5.1.5.so

libmyodbc5.la

libmyodbc5.so -> libmyodbc5-5.1.5.so

Thanks for your assistance with this.

Cheers, Ed

...from my odbc.ini file

[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

BOE120_AUDIT=auditor

%SYBASEDSN%=DataDirect 5.3 Sybase Wire Protocol Driver

[BOE120_AUDIT]

Driver=/tmp/mysql-connector-odbc-5.1.5-linux-x86-32bit/lib/libmyodbc5.so

Description=auditor

SERVER=moran.anam.com

PORT=3306

USER=Administrator

Password=

Database=BOE120_AUDIT

OPTION=3

SOCKET=

Trace=off

stmt=SET CHARACTER SET utf8

Edward Berwick wrote:

> Hi BO_Support,

>

> I hope you had a good break.

>

> Everything is going good with the version we've installed, just one question whose answer I haven't been able to track down in BOB or Unix forums.

>

> I am trying to Schedule some report for a user (well I'm in text so I'm masquerading as that same test user).

>

> The error message I'm recieving is

> "A database error occured. The database error text is: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. (WIS 10901)"

>

> We're on BOXI version 3.1 should I install the unixodbc as per the R2 document entitled?

> 'How to configure an ODBC connection to MySQL database on Linux / UNIX'

> I've been plugging away trying to install the unixodbc and have followed the install guide to the letter. I'm 90% there - as far as entering

>

> #isql -v boe120_audit

>

> to test the connection but keep coming back with a 'Segmentation fault' error, could take some time to track down and fix.

>

> According to the blurb at the beginning of your doc - "How to configure an ODBC connection to MySQL database on Linux / UNIX", it states that

> /

> Unfortunately the ODBC manager provided with BusinessObjects

> (Located in <BOinstall>/bobje/enterprise115/<OS_Pross>/odbc/lib)

> does not function correctly, as it seems that it does not include the latest

> definition for all ODBC drivers. Therefore, there is a need to replace this

> with a more up to date version./

>

> Has this been fixed in this new version BOXI 3.1?

> If not is there a more up to date version of "How to configure an ODBC connection to MySQL database on Linux / UNIX" I might use?

> If the latest ODBC drivers come with BOXI 3.1 as standard can you perhaps give me some pointers as to how I can alter the settings/config to get scheduling up and working?

>

>

> [BOE120_AUDIT]

> Driver=/tmp/mysql-connector-odbc-5.1.5-linux-x86-32bit/lib/libmyodbc5.so

> Description=auditor

> SERVER=moran.anam.com

> PORT=3306

> USER=Administrator

> Password=

> Database=BOE120_AUDIT

> OPTION=3

> SOCKET=

> Trace=off

> stmt=SET CHARACTER SET utf8