My Oracle Support Banner

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

Last updated on DECEMBER 18, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Using DG4ODBC 11.2 to connect to MS SQL SERVER database, an error occurs:
select * from
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
[Oracle][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER'.
{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 'USERi'. {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


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

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