[CentOS] [OT] Oracle->MySQL ODBC via SSL using: stock MySQL, mysql-connect or-odbc-3.51.27-0, Oracle XE

Thu May 21 19:23:27 UTC 2009
Jason Pyeron <jpyeron at pdinc.us>

I know this is very off topic, but getting MySQL and unix ODBC to play nice
via SSL on Centos has been a battle.

I finally have it working via isql but when I connect via Oracle I get an
error.

If I use the mysql odbc connector directly:

ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][MySQL][ODBC 3.51 Driver]SSL connection
error (SQL State: S1000; SQL Code: 2026)
ORA-02063: preceding 2 lines from USGNWEB


If I connect via unixODBC:


ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][unixODBC][MySQL][ODBC 3.51 Driver]SSL
connection error (SQL State: S1000; SQL Code: 2026)
ORA-02063: preceding 2 lines from USGNWEB


My assumption is that I am missing some environment variable in Oracle's
environment, but what should I look for? What information could I provide
that would be helpful?

-Jason

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                      PD Inc. http://www.pdinc.us -
- Principal Consultant              10 West 24th Street #100    -
- +1 (443) 269-1555 x333            Baltimore, Maryland 21218   -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is copyright PD Inc, subject to license 20080407P00.