Native Error 1045 and Sqlstate HY000 Using DG4ODBC to Select From MySQL
(Doc ID 781495.1)
Last updated on FEBRUARY 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]Information in this document applies to any platform.
Add *** ***
Symptoms
A Database Gateway for ODBC (DG4ODBC) connection to MySQL 5.1.30 using the MySQL 3.51 ODBC driver gives the following error connecting as the root user -
SQL> select "column_name" from "mysql_table"@mysql;
select "column_name" from "mysql_table"@mysql
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'hostname' (using
password: YES)
ORA-02063: preceding 2 lines from MYSQL
A DG4ODBC debug trace shows the following information -
Entered hgopoer at 2009/02/04-12:01:34
hgopoer, line 159: got native error 1045 and sqlstate HY000; message follows...
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'hostname' (using password: YES)
Exiting hgopoer, rc=0 at 2009/02/04-12:01:34
hgocont, line 1903: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2009/02/04-12:01:34 with error ptr FILE:hgocont.c LINE:1923
FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2009/02/04-12:01:34 with error ptr FILE:hgolgon.c LINE:612
FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2009/02/04-12:01:34
Exiting hgoexit, rc=0 at 2009/02/04-12:01:34
.
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 |