Query of non-Oracle database using DG4ODBC fails with ora-2800 with argument: unable to connect to datasource (Doc ID 1384601.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Gateway for ODBC is not connecting to the remote database. Fails with:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][unixODBC][FreeTDS][SQL Server]Unable to
connect to data source[unixODBC][FreeTDS][SQL Server]Server is unavailable or
does not exist. (SQL State: S1000; SQL Code: 0)

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