From: Ananda Kumar
Date: September 23 2005 1:30pm
Subject: Re: connectin from ORACLE to MYSQL
List-Archive: http://lists.mysql.com/mysql/189476
Message-Id: <829b199c050923063030d1835b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3505_24798401.1127482207222"

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

Hi Green,
Thanks for the email. As you said, i am also trying other resources to find
answers for this question. Just waiting for their answers.
 Since the answers were little urgent, i was little curious.
 I will let you all know once i find any solution to this.
 regards
anandkl

 On 9/23/05, SGreen@stripped <SGreen@stripped> wrote:
>
>
>
> Ananda Kumar <anandkl@stripped> wrote on 09/23/2005 05:25:10 AM:
>
> > 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 t=
o
> MYSQL
> > > 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 thi=
s
> > > 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
> > >
>
> Please admit to yourself that you know you are asking an ORACLE question
> on a MYSQL mailing list.... Have you tried reading ORACLE manuals,
> researching ORACLE list archives, and searching for ORACLE articles or
> whitepapers that deal with creating, establishing, or troubleshooting
> "heterogenous services"?
>
> I think that we do not have many people on this list with the knowledge
> you seek. We may not be able to answer your question in the time you have
> left. May I encourage you to take the initiative and research this issue
> using other resources? You will probably get better results than continui=
ng
> to ask this list. We are capable and willing to help with MySQL questions=
.
> However, this is not one.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>

------=_Part_3505_24798401.1127482207222--