This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 10, 2013 12:46 AM by kgronau Go to original post RSS
  • 15. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    A similar table works for my MySQL database connection. Just an idea that came into my mind. When you create a dummy table with a char column only, are you able to select from this column?
    And what about select user from dual@<your database link name> - does this work?
    The dual table does not exist in the MySQl database and commonly the gateway has to use an internal mechanism to get a result, does this work for you?

    - Klaus
  • 16. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Getting following error :

    Error starting at line 1 in command:
    select * from "dual"@monolith3
    Error at Command Line:1 Column:14
    Error report:
    SQL Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.20-enterprise-commercial-advanced-log]No tables used
    ORA-02063: preceding 2 lines from MONOLITH3
    28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
    *Cause:    The cause is explained in the forwarded message.
    *Action:   See the non-Oracle system's documentation of the forwarded
    message.

    Thanks,
    Vani
  • 17. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    Normally it should come back and report the user who's currently logged into the Oracle database:
    SQL> select user from dual@MYSQL_DG4ODBC_EMGTW_1123_DB;

    USER
    ------------------------------
    DG4ODBC


    So there's definitely something wrong with the driver manager or the driver itself. As I never trust rpm's from unknown sources so I downloaded the tar file from MySQL directly - the file I'm using is from the tar file: mysql-connector-odbc-5.2.2-linux-glibc2.3-x86-64bit

    Maybe you should also use the tar file - it contains the prebuilt libs and you only need to change the DRIVER parameter in the odbc.ini file pointing now to the new lib.
    - Klaus
  • 18. Re: Error while accessing DBlink to mysql
    user580543 Newbie
    Currently Being Moderated
    Hi Klaus,
    We have installed unixODBC-2.3.1 which is downloaded from
    http://www.unixodbc.org/download.html

    Also the mysql connector (mysql-connector-odbc-5.2.3-linux-glibc2.3-x86-64bit.tar.gz) downloaded from following location is installed

    http://dev.mysql.com/downloads/connector/odbc/#downloads

    -bash-3.2$ odbcinst -j
    unixODBC 2.3.1
    DRIVERS............: /usr/local/etc/odbcinst.ini
    SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
    FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
    USER DATA SOURCES..: /home/oracle/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8
    -bash-3.2$


    But unfortunately still we get the same error.

    Thanks,
    Vani
  • 19. Re: Error while accessing DBlink to mysql
    kgronau Guru
    Currently Being Moderated
    Can you please provide me an ODBC trace when you use the new driver/driver manager with the gateway and try to select from your table?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points