1 2 Previous Next 19 Replies Latest reply: Jan 10, 2013 2:46 AM by Kgronau-Oracle Go to original post RSS
      • 15. Re: Error while accessing DBlink to mysql
        Kgronau-Oracle
        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
          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-Oracle
            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
              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-Oracle
                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