1

Topic: Communication of Oracle with MySQL

I try to be connected from an Oracle DB to DB MySQL.
Made all as it is necessary - installed driver ODBC for MySQL on the server where Oracle, created a DNS-name.
In Oracle registered all necessary things in  and , created a file for heterogeneous service, created DBLink.
All made written how to be told.
I try to do of Oracle request to DB MySQL through this DBLink.
The error falls out:

ORA-28500:
[MySQL] [ODBC 5.3 (a) Driver] Access denied for user ' mysqluser ' ' aaaa.com ' (using password: YES)
...

MySQL is the DB fastened to a site.
I installed ANSI the driver, can be it is necessary was to install Unicode?
DBLink did under SYS with DBA
The same error falls out when I  for management MySQL try  with the wrong password.
In what there can be a business? What to look?

2

Re: Communication of Oracle with MySQL

The matter is that on the side mysql the necessary grants to the user are not produced. Here to you the help mysql dba is faster is necessary and to ask better in group mysql

3

Re: Communication of Oracle with MySQL

Alexander Ryndin wrote:

The matter is that on the side mysql the necessary grants to the user are not produced. Here to you the help mysql dba is faster is necessary and to ask better in group mysql

Thanks

4

Re: Communication of Oracle with MySQL

Alexander Ryndin wrote:

The matter is that on the side mysql the necessary grants to the user are not produced. Here to you the help mysql dba is faster is necessary and to ask better in group mysql

Can as that it is necessary to write the request text in another way?
I now write so:

select * from mysqltab1@MYSQLLINK

5

Re: Communication of Oracle with MySQL

The problem dared.
Business was that in MySQL  the user name is even, and  the automatic machine transforms to an uppercase the user name set in dblink without double quotes.
Too it is necessary to take the name of tables in double quotes.