DG4MSQL - Ora-28500 Native Error 4060 And Sqlstate 42000 (Doc ID 864890.1)

Last updated on FEBRUARY 07, 2013

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 07-FEB-2013


Symptoms

I'm using Database Gateway for Microsoft SQL Server (DG4MSQL) 11g.

SELECT * FROM DUAL fails with
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
.
Exiting hgogenconstr, rc=0 at 2009/07/28-17:44:03
Entered hgopoer at 2009/07/28-17:44:03
hgopoer, line 159: got native error 4060 and sqlstate 42000; message follows...
[Oracle][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'epicor_control'. Login fails.[Oracle][ODBC SQL Server Driver]Invalid connection string attribute
Exiting hgopoer, rc=0 at 2009/07/28-17:44:03
hgocont, line 1903: calling SqlDriverConnect got sqlstate 42000
Exiting hgocont, rc=28500 at 2009/07/28-17:44:03 with error ptr FILE:hgocont.c LINE:1923 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2009/07/28-17:44:03 with error ptr FILE:hgolgon.c

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