Native Error 1045 and Sqlstate HY000 Using DG4ODBC to Select From MySQL (Doc ID 781495.1)

Last updated on FEBRUARY 14, 2022

Applies to:

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

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