Hello:

I'm trying to configure Heterogeneous Services using Generic Conectivity
(ODBC) to connect from an ORACLE Database (Enterprise Oracle 8i 8.1.7)
installed on Windows 2000 ) to MySQL Database (installed on Windows 2000).

I followed all the steps in Oracle release note
114820.1  but it doesn't work.

My tnsnames.ora looks like:

hsmsql =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
   )
   (CONNECT_DATA = (SID = msql))
   (HS=OK)
 )

Listener.ora is:

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     )
   )
 )

SID_LIST_LISTENER =
 (SID_LIST =
     (SID_DESC =
        (SID_NAME = msql)
        (ORACLE_HOME = D:\orantserv)
        (PROGRAM = hsodbc)
     )
   (SID_DESC =
     (GLOBAL_DBNAME = REFDCN)
     (ORACLE_HOME = D:\orantserv)
     (SID_NAME = REFDCN)
   )
)

and I also created a file inithsodbc (on ORACLE_HOME/hs/admin) like this:
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

HS_FDS_CONNECT_INFO = msql
HS_FDS_TRACE_LEVEL = 4
#HS_FDS_SHAREABLE_NAME = C:\WINNT\System32\myodbc3.dll
HS_FDS_TRACE_FILE_NAME= c:\temp\hsmsql.trc

There is an ODBC System DSN (file) called msql (it works fine!)

I connect to user essai

I created a database link (create database link '' connect to
<user> identified by <password> using 'hsmsql'

When I try to select some data from the remote database (using SQL*PLus)

select * from toto@msql;

I got ORA-012154 : tnsnames.ora

What is wrong in this configuration

Thanks for help