From: Ananda Kumar
Date: September 23 2005 9:25am
Subject: Re: connectin from ORACLE to MYSQL
List-Archive: http://lists.mysql.com/mysql/189469
Message-Id: <829b199c05092302257519f9c2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_2437_17177940.1127467510796"

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

Hi Friends,
Any help on this is highly appreciated.
 regards
anandkl

 On 9/23/05, Ananda Kumar <anandkl@stripped> wrote:
>
> 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 MY=
SQL
> from ORACLE i am getting the below error
>  select counter from "ebay_stats"@test <%22ebay_stats%22@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_2437_17177940.1127467510796--