MySQL Forums
Forum List  »  Connector/ODBC

ORACLE ODBC USING CONNECT TO MYSQL
Posted by: GOEUN HAN
Date: January 24, 2022 01:21AM

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...

Options: ReplyQuote


Subject
Written By
Posted
ORACLE ODBC USING CONNECT TO MYSQL
January 24, 2022 01:21AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.