I have a statistical application running on RHEL 6.2. One of the data source is a MySQL 5.1 DB running on a WIN platform. I need to make ODBC or MySQL connection to retrieve data.
What I did:
I have checked yum and selected the appropriate unixOdbc and installed w/o problem.
downloaded MySQL yum repository, installed using yum, updated it, then used it to install odbc/connector.
Issue:
I only see a 0 size odbc.ini in /etc and i am not sure where to look for the odbc/connector.
Installed:
unixODBC.x86_64 0:2.2.14-14.el6
Complete
---
Installed:
mysql-connector-odbc.x86_64 0:5.3.4-1.el6
Complete!
I know that setting up environment variables is the next part and setting up DSN (odbc.ini) but I am not sure where to look (I have run searches using find cmds but not getting anything back)
Any insight is appreciated.
---------- Post updated at 04:47 PM ---------- Previous update was at 04:34 PM ----------
This is the yum list installed output so this is reporting mysql components were installed:
mysql.x86_64 5.1.69-1.el6_4 @rhel-x86_64-server-6.4.z
mysql-community-release.noarch el6-5 @/mysql-community-release-el6-5.noarch
mysql-connector-odbc.x86_64 5.3.4-1.el6 @mysql-connectors-community
mysql-libs.x86_64 5.1.69-1.el6_4 @rhel-x86_64-server-6.4.z
mysql-server.x86_64 5.1.69-1.el6_4 @rhel-x86_64-server-6.4.z
...
unixODBC.x86_64 2.2.14-14.el6 @rhel-6-server-eus-rpms