My Oracle Support Banner

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

Last updated on JUNE 21, 2018

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

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.