My Oracle Support Banner

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

Last updated on APRIL 09, 2020

Applies to:

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


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)
SQLHDBC 0x11014200
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 * 0x7fffdbb99000 (93)


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.