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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Ananda Kumar <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > MYSQL > > > from ORACLE i am getting the below error > > > select counter from "ebay_stats"@test <[EMAIL PROTECTED]> 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 = myodbc3 > > > HS_FDS_TRACE_LEVEL = off > > > HS_FDS_TRACE_FILE_NAME = <log file name> > > > HS_FDS_SHAREABLE_NAME = /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 continuing > 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 > >
