I have set my HS parameter in my Oracle10g and I know I have set the connect info but when I want to run a simple SQL connecting to a remote server with SQLSERVER 8.0 I am getting the below message, can anybody help me on that?
SQL> select * from mg5@mysqlserverdsn;
select * from mg5@mysqlserverdsn
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][H006] The init parameter
<HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
ORA-02063: preceding 2 lines from MYSQLSERVERDSN
SQL> select * from mg5@mysqlserverdsn;
select * from mg5@mysqlserverdsn
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][H006] The init parameter
<HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
ORA-02063: preceding 2 lines from MYSQLSERVERDSN
