Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

NO CONNECT TO MYSQL USING dg4odbc

edited Jul 16, 2013 4:37AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 3 commentsAnswered ✓

select * from "bugs"@BB;ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 5.1 Driver]Access denied for user 'BUGS'@'localhost' (using password: YES) {HY000,NativeErr = 1045}
ORA-02063: preceding 2 lines from BB
28500. 00000 -  "connection from ORACLE to a non-Oracle system returned this message:"
*Cause:    The cause is explained in the forwarded message.
*Action:   See the non-Oracle system's documentation of the forwarded
           message.
Error at Line: 1 Column: 22

My OS: Windows XP

My database:   Database 11.2.0.2.0
I connect to:
Server version: 5.1.44-community-log MySQL Community Server (GPL)
database: bugs

I created SYSTEM DSN    data_source_name =  BB    using %SystemRoot%\system32\odbcad32.exe

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center