From: Ananda Kumar
Date: September 23 2005 5:14am
Subject: connectin from ORACLE to MYSQL
List-Archive: http://lists.mysql.com/mysql/189462
Message-Id: <829b199c050922221423090e80@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_1660_32409489.1127452499644"

------=_Part_1660_32409489.1127452499644
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi Friends,
I have set up all the drivers and configured the Hetrogenous service in
oracle and set all the relevent parameter. Now when i am connecting to MYSQ=
L
from ORACLE i am getting the below error
 select counter from "ebay_stats"@test where rownum < 2
*
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_SHAREABLE_NAME> is not set. Please set it in init<orasid>.ora file.
ORA-02063: preceding 2 lines from TEST
  I have set the HS_FDS_SHAREABLE_NAME also in the initmyodbc3.ora file
located in $ORACLE_HOME/hs/admin path
 HS_FDS_CONNECT_INFO =3D myodbc3
HS_FDS_TRACE_LEVEL =3D off
HS_FDS_TRACE_FILE_NAME =3D <log file name>
HS_FDS_SHAREABLE_NAME =3D /usr/local/lib/libmyodbc3.so
 Please help me.
 regards
anandkl

------=_Part_1660_32409489.1127452499644--