Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have installed R 2.13 in opensuse 11.04. I wanted to access a MySQL db using R. I Installed RODBC without any error. I can even load the RODBC (usinglibrary('RODBC')). When I tried to connect to db using

library(RODBC)
channel = odbcDriverConnect(connection = "Driver={MySQL ODBC 5.1 Driver};Server=myserver;Database=db;User=me;Password=***;", readOnlyOptimize = TRUE)

It says,

Warning messages:

1: In odbcDriverConnect(connection = "Driver={MySQL ODBC 5.1 Driver};Server=server;Database=bd;User=me;Password=abcd;",  :
  [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2: In odbcDriverConnect(connection = "Driver={MySQL ODBC 5.1 Driver};Server=server;Database=db;User=me;Password=abcd;",  :
  ODBC connection failed

How do I solve this ?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.