RODBC not connecting to MySql from mac

General
, ,
1

Hi all,

I am using mac and I came across a problem when running this code:

library(RODBC)
b <- odbcConnect("myodbc", uid="root", pwd="12345678")

It just seems to run for ages and nothing appeared but a red sign of "stop" at the top of the console. After clicking on the red sign, I got 'There were 50 or more warnings (use warnings() to see the first 50)'. Some warnings are like:

Warning messages:
1: In RODBC::odbcDriverConnect("DSN=myodbc;UID=root;PWD=12345678") :
[RODBC] ERROR: state 00000, code 280146816, message [iODBC][Driver Manager]dlopen(/usr/local/mysql-connector-odbc-8.0.22-macos10.15-x86-64bit/lib/libmyodbc8w.so, 6): image not found
2: In RODBC::odbcDriverConnect("DSN=myodbc;UID=root;PWD=12345678") :
[RODBC] ERROR: state IM003, code 280146816, message [iODBC][Driver Manager]Specified driver could not be loaded
3: In RODBC::odbcDriverConnect("DSN=myodbc;UID=root;PWD=12345678") :
[RODBC] ERROR: state IM003, code 280146816, message [iODBC][Driver Manager]Specified driver could not be loaded

All other warnings are just like the last one as above.

Anybody could help me? Thank you!!

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.