DG4ODBC And ORA-1017 Login Failed invalid username/password - logon denied (Doc ID 1250187.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Feb-2016 ***

Symptoms


Using DG4ODBC 11.2 to connect to MS SQL SERVER database, an error occurs:
select * from dual@itsm7.drs.infineon.com
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
[Oracle][ODBC SQL Server Driver][SQL Server]Login failed for user 'Mimi'.
{28000,NativeErr = 18456}[Oracle][ODBC SQL Server Driver]Invalid connection
string attribute {01S00}
ORA-02063: preceding 2 lines from ITSM7.DRS.INFINEON.COM

Gateway trace file  shows:

hgopoer, line 233: got native error 18456 and sqlstate 28000; message follows...
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Mimi'. {28000,NativeErr = 18456}[Microsoft][ODBC Driver Manager] Invalid connection string attribute {01S00}
Exiting hgopoer, rc=0 at 2010/09/15-11:29:50
hgocont, line 2753: calling SqlDriverConnect got sqlstate 28000
Exiting hgocont, rc=1017 at 2010/09/15-11:29:50 with error ptr FILE:hgocont.c LINE:2753 ID:SQLDriverConnect
Exiting hgolgon, rc=1017 at 2010/09/15-11:29:50 with error ptr FILE:hgolgon.c LINE:781 ID:Calling hgocont

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