Heterogenious services.

[Dosth]

I have a access database which I 'm trying to access using Heterogenious services.

My initavantiaccess.ora file in HS\admin folder and Tnsnames.ora in network/admin folder are in place.

hs\initavantiaccess.ora
--

HS_FDS_CONNECT_INFO = avantiaccess
HS_FDS_TRACE_LEVEL = OFF


--

Network\admin\tnsnames.ora
--
avantiaccess =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=STRATSOURCING)(PORT=1521))
(CONNECT_DATA=(SID=avantiaccess))
(HS=)
)


--
Listener.ora
--
(SID_DESC=
(SID_NAME=avantiaccess)
(ORACLE_HOME=D:\Oracle\Ora81)
(PROGRAM=hsodbc.exe)
)




I could tnsping the service name.


I also created a db link.

When I query the database now , I get the following error

SQL> select * from accounts@avantiaccess;
select * from accounts@avantiaccess
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 12564
ORA-02063: preceding 2 lines from AVANTIACCESS

Any IDEAS on why I have this error and Am I missing something ?

Help me please. thanks in advance

Dosth

[TomazZ]

In tnsnames.ora you should have
HS=OK

[Dosth]

Thanks Tom, But I still have the same problem ... :(