HS ODBC - DBLINK

From: cjn <anne-marie.caujan_at_ago.fr>
Date: 20 Sep 2004 08:56:10 -0700
Message-ID: <716b9c94.0409200756.5c800f85@posting.google.com>

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_at_msql;

I got ORA-012154 : tnsnames.ora

What is wrong in this configuration

Thanks for help Received on Mon Sep 20 2004 - 10:56:10 CDT