14 Replies Latest reply on May 30, 2018 4:16 PM by amakitalo

    ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from "dblink"

    Carl C

      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