HSODBC

Configurazione parte client MYSQL:


Configurazione lato Oracle: 

1- Configurare il TNS NAMES: 

MYSQL =
 (DESCRIPTION=
   (ADDRESS_LIST=
     (ADDRESS= (PROTOCOL = TCP)
               (HOST = <server.mysql.com>)
               (PORT = 1521)
     )
   )
   (CONNECT_DATA=
     (SID=mysql)
   )
   (HS=OK))

2- Configurazione di Listener dedicato:

 LISTENER_MYSQL =
(ADDRESS_LIST=
     (ADDRESS=(PROTOCOL=tcp)(HOST=<server.mysql.com>)(PORT=1521))
)

SID_LIST_LISTENER_MYSQL=
  (SID_LIST=
    (SID_DESC =
       (GLOBAL_DBNAME= <dbname>)
       (ORACLE_HOME = /u01/app/oracle/product/11g/orahome11g)
       (SID_NAME = <db>)
    )
    (SID_DESC =
      (SID_NAME = mysql)
      (ORACLE_HOME = /u01/app/oracle/product/11g/orahome11g)
      (ENVS="LD_LIBRARY_PATH=/usr/lib:/opt/mysql/lib:/u01/app/oracle/product/11g/orahome11g/lib")
      (PROGRAM = dg4odbc)
    )
 )