MySQL Forums
Forum List  »  MySQL for Excel

Could not connect to MySQL ODBC 5.1
Posted by: Aparna Jonnavittula
Date: March 05, 2013 10:26PM

Hello,

I have configured MySQL ODBC 5.1 on Linux Server but it gives me error as below when I try to connect:

isql -v test_mysql
[S1000][unixODBC][MySQL][ODBC 5.1 Driver]Unknown database 'test'

I have installed mysql-connector-odbc-5.1.11 for linux and configured odbc.ini as below:

[test_mysql]
Driver=/usr/lib64/libmyodbc5.so
Description=Connector/ODBC 5.1 Driver
SERVER=192.XXX.XXX.XX
PORT=3306
USER= ysql_user
Password=mysql_user
Database=test
OPTION = 3
SOCKET=/var/lib/mysql/mysql.sock

Please help me with this.

Regards,
Aparna.

Options: ReplyQuote


Subject
Views
Written By
Posted
Could not connect to MySQL ODBC 5.1
2749
March 05, 2013 10:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.