oracle heterogeneous services and mysql

From: Hans <florian_at_genetic-art.de>
Date: Sat, 19 Jan 2002 23:47:25 +0100
Message-ID: <a2cs8m$ja8$1@news.netcologne.de>

Hi,
I have tried to create a Database Link between an Oracle and Mysql DB via Oracle heterogeneous services.
For the ODBC Driver I used MyODBC from the mysql.com website. The ODBC Driver is working but the problem is when I try to connect to the Mysql DB via the Database Link I get the following Error :

ORA-28500 [Generic connectivity using ODBC} [TCX] [MyODBC] acces denied for 'user test_at_sputnik' (Using Password: yes) SQL Code 1045) ORA-02063 2 lines from HSODBC

The user configuration in Mysql for the user test in the mysql DB is O.K. Maybe somebody has some experience in creating an heterogeneous service between Oracle and Mysql and give me some hints were the error is.

thanks for your help,
Hans

Here are my config files:

# TNSNAMES.ORA Network Configuration File: f:\oracle\ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )
SOLARIS1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sputnik)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = Solaris1)

    )
  )

hsodbc = (DESCRIPTION=

            (ADDRESS=(PROTOCOL=tcp)(HOST=sputnik)(PORT=1521))
            (CONNECT_DATA=(SID=hsodbc))
            (HS= OK)
          )

# LISTENER.ORA Network Configuration File: f:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = sputnik)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = sputnik)(PORT = 2481))

    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = Solaris1)
(ORACLE_HOME = f:\oracle\ora81)
(SID_NAME = Solaris1)

    )

    (SID_DESC=
    (SID_NAME=hsodbc)
    (ORACLE_HOME=f:\oracle\ora81)
    (PROGRAM=hsodbc)
     )

)

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#

HS_FDS_CONNECT_INFO = apollo11
HS_FDS_TRACE_LEVEL = OFF#

# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Received on Sat Jan 19 2002 - 16:47:25 CST