Oracle, MySQL connectivity by HSODBC

Tags:
Database connectivity
HSODBC
MySQL
ORA-02063
ORA-28545
Oracle
Oracle 10g
Oracle error messages
Solaris
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows platform (Windows XP) My question is how to resolve this problem and is there any other way to connectivity between MySQL and Oracle?
ASKED: October 26, 2008  6:04 AM
UPDATED: October 27, 2008  6:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It is probably a configuration issue.
Things to check:

- You have created an ODBC connection to your MySql database and you have tested it from outside Oracle, and it is working well.
- Your Oracle global_names parameter is set to false (init.ora)
- You have configured the hetergeneous services. (This consists of creating an initodbc.ora)
- You have configured the listener to point to the heterogeneus service (listener.ora)
- You have created a new connection in your tnsnames.ora file
- You have restarted your listener service.
- You have created a database link

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following