dg4odbc_agt_238936.txt (10.98 KB)dg4odbc_agt_238986.txt (10.98 KB)dg4odbc_agt_239008.txt (10.98 KB)Hi,
I am exploring Oracle Gateway to connect to different data source. I successfully using Oracle gateway connect to DB2 and MSSQL, however, I have difficulty connect to splunk via odbc.
In my configruation, I have splunk running on the same host as Oracle gateway and installed the following 3 rpm(s).
unixODBC
unixODBC-devel
cdata-odbc-driver-for-splunk-22.0-8322.x86_64
My odbc configuration is
[oracle@down2 admin]$ odbcinst -q -d
[PostgreSQL]
[MySQL]
[FreeTDS]
[MariaDB]
[CData ODBC Driver for Splunk]
[oracle@down2 admin]$ odbcinst -q -s
[splunk]
[CData Splunk Sys]
[oracle@down2 admin]$
My initdb4odbc.ora is
[oracle@down2 admin]$ grep -v '#' initdg4odbc.ora
HS_FDS_CONNECT_INFO = splunk
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_SHAREABLE_NAME = /opt/cdata/cdata-odbc-driver-for-splunk/lib/libsplunkodbc.x64.so
set ODBCINI=/etc/odbc.ini
[oracle@down2 admin]$ cat /etc/odbc.ini
[splunk]
#[CData Splunk Source]
Driver=CData ODBC Driver for Splunk
Description=My Description
user=admin
password=oracle_4U
URL=http://192.168.2.248:8000
[CData Splunk Sys]
Driver=CData ODBC Driver for Splunk
Auth Scheme=Basic
Password=
URL=
User=
[oracle@down2 admin]$
When I try to make dblink connection, I got the following error:
Error starting at line : 6 in command -
select * from pojen@odbcpojen
Error at Command Line : 6 Column : 21
Error report -
SQL Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
I
I tried with simple python code to make sure odbc setting is correct, i.e.,
From the trace file, it seems to suggest there is a problem with splunk odbc driver ,ie.,
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
treat_SQLLEN_as_compiled = 1
...
Entered hgopoer at 2022/12/02-02:57:11
hgopoer, line 240: got native error -1 and sqlstate 0; message follows...
I
Exiting hgopoer, rc=0 at 2022/12/02-02:57:11
hgocont, line 2918: calling SQLConnect got sqlstate 0
Exiting hgocont, rc=28500 at 2022/12/02-02:57:11 with error ptr FILE:hgocont.c LINE:2938 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2022/12/02-02:57:11 with error ptr FILE:hgolgon.c LINE:785 ID:Calling hgocont
Any help is appreciated. Thank you.
environment: OEL8x64, Oracle Gateway 21, Oracle database 21.8 (on-perm), Splunk 9.02-17