My Oracle Support Banner

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 SEPTEMBER 27, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 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

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
Symptoms
Cause
Solution


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