Oracle Database Discussions

Hi all,

I set global_names to TRUE. I am working on db_link between Oracle and MS sql server.

The init file:

HS_FDS_CONNECT_INFO=MyHost,1433/master

HS_FDS_TRACE_LEVEL=debug

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

HS_DB_DOMAIN=MyDomain

HS_DB_NAME=SQLEXPRESS

alter session set global_names=TRUE;

drop public database link sqlexpress.MyDomain;

CREATE  PUBLIC DATABASE LINK "SQLEXPRESS.MyDomain"   CONNECT TO "SA" IDENTIFIED BY "xxxxxx"     USING 'dg4msql';  

select * from dual@SQLEXPRESS.MyDomain; When I try to execute the this query I get the below error

ORA-28536: erreur de traitement des paramètres d'initialisation des services hétérogènes

ORA-28508: valeur SQLEXPRESS non valide pour le paramètre d'init. des services hétérogènes HS_DB_NAME

ORA-02063: précédant 2 lines de SQLEXPRESS.

do you have any idea how can I fix this?

Thanks,