My Oracle Support Banner

Cannot Select Uniqueidentifier Columns from SQL*Server Using Database Gateway for SQLSERVER (DG4MSQL) (Doc ID 787449.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database Gateway for SQL Server - Version to [Release 11.1]
Information in this document applies to any platform.


Columns defined as datatype uniqueidentifier in SQL*Server cannot be selected using 11g Database Gateway for SQL*Server.
The columns can be selected using the 10.2 Transparent Gateway for SQL*Server.

A gateway debug trace will show something similar to the following for columns defined as uniqueidentifier datatype -

Entered hgopcda at 2009/01/26-18:12:38
Column:3(Uniqcolumn): dtype:-11 (GUID), prc/scl:36/0, nullbl:1, octet:0, sign:1, radix:10
Column 3 (Uniqcolumn): dtype -11 (GUID): this datatype is not supported.



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.