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
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