ORA-28500 - Unable to Connect to Data Source - Using DG4ODBC and FreeTDS ODBC Driver (Doc ID 1309708.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Add ***Checked for relevance on 04-Sep-2012***

Symptoms




Using Dg4ODBC 11.2.0.1 on Linux x86-64 with the FreeTDS ODBC driver a select gives the following error -

SQL> select * from Table@GATEWAY;
select * from Table@GATEWAY
*
ERROR line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
{08001}[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed


A DG4ODBC debug trace shows the following information -


Entered hgopoer at 2011/03/29-21:28:20
hgopoer, line 233: got native error 0 and sqlstate 08001; message follows...
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source {08001}[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed {01000,NativeErr = 20002}[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server {01000,NativeErr = 20017}
Exiting hgopoer, rc=0 at 2011/03/29-21:28:20
hgocont, line 2752: calling SqlDriverConnect got sqlstate 08001
Exiting hgocont, rc=28500 at 2011/03/29-21:28:20 with error ptr FILE:hgocont.c LINE:2772 FUNCTION:hgocont() ID:Something other than invalid authorization

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