Hi all,

our oracle 10g database is on AIX 5.2 and i configures heterogeneous service and install oracle 10g cleint on windows 2003 server where SQL Server reside . i configured the following things but i got the error *ORA-02019*. please help me its very urgent. quick response will higly appreciated. thanks alot in advance.

1)create Sytem DSN (mysqlserver) by selectin SQL Native cleint
2)copy the existing entry and paste it in listener.ora file and edit it as below
LISTENERMYSQLSERVERDSN =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST= hostname of oracle database)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_ =
(SID_LIST=
(SID_DESC=
(SID_NAME= mysqlserver)
(ORACLE_HOME = /u01/app/oracle/product/101)
(PROGRAM=hsodbc)
)
)
$lsnrctl status LISTENERMYSQLSERVERDSN

It is working fine

3) configure TNAMES.ora

mysqlserver =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 100.100.50.5)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = mysqlserver)
(HS = OK)
)
)

c:>tnsping mysqlserver

it is workin fine


4)copy inithsodbc.ora and make it initmysqlserver.ora


HS_FDS_CONNECT_INFO = mysqlserver
HS_FDS_TRACE_LEVEL = off


4)create the database link

sql>create database link mysqlserver
connect to "sa" identified by "nsp@123" using 'mysqlserver';


when i selecting SQL Server object from oracle i got below error

SQL> select * from NSP_products@mysqlserver;
select * from NSP_products@mysqlserver
*
ERROR at line 1:
ORA-02019: connection description for remote database not found


pLease help me its very urgent.


BEST REGARD