Error on First Select When Querying Sand Technologies Database Using DG4ODBC (Doc ID 1129495.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms


You are using Database Gateway for ODBC (DG4ODBC) 11.2 on Linux x86-64 to connect to a Sand Technologies database using DataDirect and Openlink ODBC drivers.
The first select gives errors -

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[ODBC][Nucleus ODBC Driver][aznucquat_oct]Octopus Error: Octopus is running in
Read Only mode {Q0100,NativeErr = 436207872}
ORA-02063: preceding 2 lines from DBLINK



but subsequent selects work successfully.
A DG4ODBC trace shows for the first select -


Entered hgopoer at 2010/05/27-11:54:52
hgopoer, line 233: got native error 436207872 and sqlstate Q0100; message follows...
[ODBC][Nucleus ODBC Driver][aznucquat_oct]Octopus Error: Octopus is running in Read Only mode {Q0100,NativeErr = 436207872}
Exiting hgopoer, rc=0 at 2010/05/27-11:54:52
hgobegn, line 261: calling SQLSetConnectAttr got sqlstate Q0100
Exiting hgobegn, rc=28500 at 2010/05/27-11:54:52 with error ptr FILE:hgobegn.c LINE:261 FUNCTION:hgobegn() ID:Transaction Isolation Level


and an ODBC trace shows -


dg4odbcaznucqua 2BA0D8D912F0 EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x11014200
SQLSMALLINT 1
SQLCHAR * 0x7fffdbb98fb0
| Q0100 |
SQLINTEGER * 0x7fffdbb98da4 (436207872)
SQLCHAR * 0x7fffdbb98db0
| [ODBC][Nucleus ODBC Driver][aznucquat_oc |
| t]Octopus Error: Octopus is running in R |
| ead Only mode |
SQLSMALLINT 510
SQLSMALLINT * 0x7fffdbb99000 (93)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms