MySQL connectivity issue with Business objects reporting via Linux

[Karthik Kumar]

Hi Members,

I'm trying to establish a connection to MYSQL community server 1.5.30 from Business objects (BO) reporting XI R3.1 SP5 application installed in Red Hat Linux 4. Recently we have installed MySQL RPM package 2.50.39 odbc connector in this Linux server. I've set all the required environment variables & sourced it. Also added the Data source name entry in ODBC.ini file.

When I tried conneccting to MySQL community server through the BO application in Linux application, getting the below error code.

SQLConnect: Retrying Connect.
SQLSTATE = 81
NATIVE ERROR = 0
MSG = 523 80

Can anyone please suggest me what this error code represents and is there a way to establish a connection to MySQL community server? Please let me know if you need further details.

Thanks,
Karthik