Skip to Content
0
Former Member
Feb 10, 2009 at 10:42 AM

How to correctly configure an ODBC connection to a MySQL dB on Linux

163 Views

Hi,

I'm running BOXI 3.1 on Red Hat Ent 5.0 Linux.

I ca't schedule or seem to connect with my datasource off my Linux machines. I can view but not Edit getting the error

A​ ​d​a​t​a​b​a​s​e​ ​e​r​r​o​r​ ​o​c​c​u​r​e​d​.​ ​T​h​e​ ​d​a​t​a​b​a​s​e​ ​e​r​r​o​r​ ​t​e​x​t​ ​i​s​:​ ​[​u​n​i​x​O​D​B​C​]​[​M​y​S​Q​L​]​[​O​D​B​C​ ​5​.​1​ ​D​r​i​v​e​r​]​A​c​c​e​s​s​ ​d​e​n​i​e​d​ ​f​o​r​ ​u​s​e​r​ ​'​e​b​e​r​w​i​c​k​'​@​'​l​o​c​a​l​h​o​s​t​'​ ​(​u​s​i​n​g​ ​p​a​s​s​w​o​r​d​:​ ​Y​E​S​)​.​ ​(​W​I​S​ ​1​0​9​0​1​)

I looked up and followed the official BO documentation. See link for exactly where I got to on this.

[http://spreadsheets.google.com/pub?key=p5H_wgxjwr3kjQQNs68BsDw]

It all seemed to have come undone when I tried to do the isql test where I encountered a Fault Segmentation error. I'll try anything to get this resolved.

Would I be better off trying to connect with DataDirect?

Cheers, Ed