database link from Oracle to MYSQL

Posted by Roshan on Jan 08, 2019; 10:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/database-link-from-Oracle-to-MYSQL-tp7056.html

Oracle Database 12.1.0.2
Red Hat Linux 6

Hello Erman,

Happy New Year 2019!

I have  configured ODBC to connect from Oracle to MYSQL(Windows server). Before that, I installed MYSQL on the source Linux server and connection is fine as shown below

-bash-4.1$ isql -v demo
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

ODBC entry:
[demo]
Driver = /usr/lib64/libmyodbc8a.so
Description = Connector/ODBC x.x Driver DSN
SERVER = 127.0.0.1
PORT = 3306
USER = demo
PASSWORD = AAAA
DATABASE = demo
OPTION = 0
TRACE = Yes

When I am trying to connect to the MYSQL on Windows server, I am getting error shown below:

-bash-4.1$ isql -v bikwik
[S1000][unixODBC][MySQL][ODBC 8.0(a) Driver]Access denied for user 'roshanbi'@'localhost' (using password: NO)
[ISQL]ERROR: Could not SQLConnect

ODBC entry for 'bikwik'

[bikwik]
Driver = /usr/lib64/libmyodbc8a.so
Description = Connector/ODBC x.x Driver DSN
SERVER = 10.10.10.111
PORT = 3306
USER = root
PASSWORD = AAAA
DATABASE = mt
OPTION = 0
TRACE = Yes

ping and telnet is fine.

Please advise.

Regards,

Roshan