Re: Heterogeneous service to MySQL

From: PeterS <member9017_at_dbforums.com>
Date: Tue, 15 Apr 2003 18:15:35 +0000
Message-ID: <2770281.1050430535@dbforums.com>

Originally posted by Mark D Powell
> PeterS wrote in message news:news:...
> > Thank you for reply, Daniel.
> > I didn't mentioned that I've gone through HS Admin guide
> and
> > configured HS to MySQL. But I cannot connect to MySQL db.Here is
> the
> > errors I am getting;
> > SQL> select * from tbl_ru_at_hsodbc;
> > select * from tbl_ru_at_hsodbc
> > *
> > ERROR at line 1:
> > ORA-28500: connection from ORACLE to a non-Oracle system
> returned
> > this message:
> > [Generic Connectivity Using ODBC]DRV_InitTdp: [MySQL][ODBC
> 3.51
> > Driver]Access
> > denied for user: 'QATOOLS_at_10.5.72.133' (Using password: YES)
> (SQL
> > State: S1000;
> > SQL Code: 1045)
> > ORA-02063: preceding 2 lines from HSODBC
> >
> > Can you suggest anything?
> >
> > Originally posted by Daniel Roy
> > > Read the "Heterogeneous Connectivity Administrator's Guide"
> on
> > > tahiti.oracle.com. That explains everything you need in
> detail.
> > >
> > > Daniel
> > >
> > > PeterS wrote in message
> news:news:news:news:...
> > > > Hello everybody!
> > > > Does anybody know how to configure HS to connect from
> Oracle
> > db
> > > > to MySQL db.
> > > > Particularly I need to know what agent to start and where
> to
> > find it.
> > > >
> > > > Thanks a lot in advance!
> > > >
> > > Peter.

>

> Peter, I think the sqlstate codes are in the Pro*C manual so whatever
> S1000 is might help you. I suspect that the 1045 is an ORA-01045 and
> Oracle is returning it as being Oracle's closest related error. This
> would make the mean the problem probably relates to the
> userid/password in use missing a necessary privilege. If you are
> running on NT it could relate to the domain privilege since I seem to
> remember running into that. I also seem to remember something about
> having to put the userid/passord in quotes within the ODBC ini file.
>
> HTH -- Mark D Powell --

Hello, Mark.
Thank you for reply!
I actually figured out my problem. You are right in that in db link creation clause CONNECT TO "user" IDENTIFIED BY "password" user and password have to be enclosed in double quotes. I did not touch ODBC ini file, though!
Everything worked fine. I wrote up a document and would be happy to send it to you or post it somewhere. Let me know if you need it.

Peter S.

--
Posted via http://dbforums.com

Received on Tue Apr 15 2003 - 13:15:35 CDT