ORACLE ODBC USING CONNECT TO MYSQL

[GOEUN HAN]

Dear experts,



I am working on setting up a MYSQL ODBC. and I tried to query with DB LINKS.

but it showed errors message. but, isql method can access mysql server.



i installed odbc with root. here is my question. why it is the different odbcinist when i commaned with oracle account.

so i guesss that when it try to connect with ORACLE HS, it can't find ODBC... please my experts save me..



[root@doj-stg-api-ora-01 etc]# odbcinst -j

unixODBC 2.3.4

DRIVERS............: /usr/local/etc/odbcinst.ini

SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini

FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources

USER DATA SOURCES..: /root/.odbc.ini

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8





su - oracle odbcinst -j



[oracle@doj-stg-api-ora-01 ~]$ odbcinst -j

unixODBC 2.3.1

DRIVERS............: /etc/odbcinst.ini

SYSTEM DATA SOURCES: /etc/odbc.ini

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /home/oracle/.odbc.ini

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8



-------------------------------------------------------------------------------------------------------------------------

[root@doj-stg-api-ora-01 etc]# isql MYSQL "skbb"

+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |





SQL> select * from auth_token@MYSQL;

select * from auth_token@MYSQL



ERROR at line 1:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

ORA-02063: preceding line from MYSQL





setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

setting HS_FDS_MAP_NCHAR to default of "TRUE"

setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

setting HS_FDS_QUERY_DRIVER to default of "TRUE"

setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"

setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION

setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo;gtw$:OPTTables;gtw$:OPTColumns;gtw$:OPTPrimaryKeys;gtw$:OPTForeignKeys;gtw$:OPTProcedures;gtw$:OPTStatistics"

setting HS_FDS_DELAYED_OPEN to default of "TRUE"

setting HS_FDS_WORKAROUNDS to default of "0"

setting HS_WORKAROUNDS to default of "0"

Exiting hgosdip, rc=0

ORACLE_SID is "MYSQL"

Product-Info:

Port Rls/Upd:0/0 PrdStat:0

Agent:Oracle Database Gateway for ODBC

Facility:hsa

Class:ODBC, ClassVsn:19.0.0.0.0_0024, Instance:MYSQL

Exiting hgogprd, rc=0

HOA 01/24 15:31:51.286248000: (hotker_ExecuteRpcs) ncrorpi: status = 0

HOA 01/24 15:31:51.289866000: (hotker_ExecuteRpcs) ncrorpi: status = 0

Entered hgoinit

HOCXU_COMP_CSET=1

HOCXU_DRV_CSET=846

HOCXU_DRV_NCHAR=873

HOCXU_DB_CSET=846

HS_LANGUAGE is AMERICAN_AMERICA.KO16MSWIN949

LANG=ko_KR.UTF-8

HOCXU_SEM_VER=122020

HOCXU_VC2_MAX=4000

HOCXU_RAW_MAX=2000

Entered hgolofn at 2022/01/24-15:31:51

No ODBC library specified.

Exiting hgolofn, rc=28500 at 2022/01/24-15:31:51

Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:442 ID:Loading ODBC aray of function ptrs

HOA 01/24 15:31:51.290558000: (hotker_ExecuteRpcs) ncrorpi: status = 0

Entered hgoexit

HS Gateway: NULL connection context at exit

Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:118 ID:Connection context

HOA 01/24 15:31:51.290602000: (hotker_ExecuteRpcs) Exiting...

HOA 01/24 15:31:51.290623000: (horcrces_CleanupExtprocSession) Entered!

HOA 01/24 15:31:51.290631000: (horcrpooe_PopOciEnv) Entered!

HOA 01/24 15:31:51.290639000: (horcrfoe_FreeOciEnv) Entered!

HOA 01/24 15:31:51.290646000: (horcrfoe_FreeOciEnv) Exiting...

HOA 01/24 15:31:51.290653000: (horcrfse_FreeStackElt) Entered!

HOA 01/24 15:31:51.290661000: (horcrfse_FreeStackElt) Exiting...