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
