MySQL ODBC Driver connection problem

"Milan Thakkar" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <A618710A15BB4C43BCAAF29CDF7441480C63A2@SITE2MAIL02.jeeves.ask.info>
Hi,
 
I have successfully setup unixODBC Manager and MySQL ODBC Drivers and
was able to connect to MySQL Server from my oracle database.
 
Now, today, when i am trying to connect to MySQL Server i am getting
following error:
 
SQL> select count("user_id") from "USER_SRCH_TBL"@mysqldb;
select count("user_id") from "USER_SRCH_TBL"@mysqldb
                                             *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][unixODBC][MySQL][ODBC 3.51
Driver]Can't
connect to MySQL server on 'devfwp2' (146) (SQL State: S1000; SQL Code:
2003)
ORA-02063: preceding 2 lines from MYSQLDB

 
This was working fine before. I havent changed anything on both the
side.
 
Please help me regarding this.
 
Thanks
 
Milan Thakkar
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.