Hi anne-marie
really i'm supposed to be going to bed not reading cdos but I do have a
relaticely simple howto on my site for generic connectivity if you wish to
compare what you have done with that you are more than welcome.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
"cjn" <anne-marie.caujan_at_ago.fr> wrote in message
news:716b9c94.0409200756.5c800f85_at_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 - 16:23:26 CDT
