CODEWITHSUNDEEP
mysqlodbc
ashim
ashim

Reputation: 25560

driver ODBC does not work with MySQL

I want use MySQL database in R environment. I am using Ubuntu OS. To do this I should install unixODBC or iodbc and install odbc driver for MySQL. I encounter with error in R when I want connect to database: file /usr/lib/odbc/libmyodbc.so not found. But of course that file is in that directory. I googled everything I think. the only clue I have that it is probably problem with mysql odbc driver, it does not see the file (why?). Any help is appreciated.

There is work around to this problem - use rmysql package for R. Nice!

Upvotes: 2

Views: 635

Answers (2)

blunders
blunders

Reputation: 3669

The "RMySQL" package on CRAN is what you need, here a link for more info:

http://cran.r-project.org/web/packages/RMySQL/

Found the above by Googling "R MySQL".

(NOTE: This answer was first posted as a comment, but worked, so I'm posting it as the answer to clean up the page.)

Upvotes: 1

Its not blank
Its not blank

Reputation: 3095

You have different driver for MySql its probably mySQLconnector.Try using this .You dont need to use ODBC drivers for this.

Upvotes: 0

Related Questions