My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.