Oracle Database Discussions

Hi Gurus,

I'm facing an issue with my odbc connection through Oracle into MySQLwith this error  When I run this query

SQL> select “id_chart“ from "ipw_chart"@ipw

  2  ;

*

ERROR at line 2:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

ORA-02063: preceding line from IPW

Access to MySQL database MySQL with ISql seems fine which make me conclude the issue comes from Oracle.

-bash-4.2$ isql -v IPW

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

I've already check all config files, Listener, Tnsnames initHSSID, odbc.ini, drivers, environment variables, read tonnes of pages in google regarding this issue.

Any Ideas?

Thank you in advance