Hello,
I have a problem to connect MySQL server with a Oracle.
I have try to compile all tips in this forum for fix it without success.
It give me back ORA-28500: [unixODBC][DriverManager]Datasourcename{i}
I post all my config, perhaps someone can help me
Oracle database Enterprise 12.2.0.1
mysql-connector-odbc-5.3.9-linux-x86-64bit
odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
/etc/odbc.ini
[bggpbc_deeptown]
Driver=MySQL ODBC 5.3.9 x64 driver unicode
SERVER=10.230.78.123
UID=user
PWD=pwd
DATABASE=deeptown
PORT=3306
/etc/odbcinst.ini
[MySQL ODBC 5.3.9 x64 driver unicode]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=1
[MySQL ODBC 5.3.9 x64 driver ansi]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=1
When i do an isql -v bggpbc_deeptown, it is Ok. I can do a select on remote MySQL server and database
/u01/app/oracle/product/12.1.0/dbhome_1/hs/admin/initbggpbc_deeptown.ora
HS_FDS_CONNECT_INFO=bggpbc_deeptown
HS_FDS_TRACE_LEVEL=off
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
set ODBCINI=/etc/odbc.ini
set ODBCSYSINI=/etc
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
bggpbc_deeptown=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA=
(SID="bggpbc_deeptown")
)
(HS=OK)
)
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=bggpbc_deeptown)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
(PROGRAM=dg4odbc)
)
)
When I do
CREATE PUBLIC DATABASE LINK bggpbc_deeptown CONNECT TO "user" IDENTIFIED BY "pwd" USING 'bggpbc_deeptown';
SELECT * FROM materiaux@bggpbc_deeptown;
ORA-28500: ... [unixODBC][DriverManager]Datasourcename{i}
ORA-02063: ...
Thank you for your help.