talksopk.blogg.se

How to add ODBC to MAMP on OSX led me to think that is was a 32-bit vs 64-bit problem.

I was getting this error when testing it in iODBC Administrator: dlopen(/usr/local/lib/libmyodbc5w.so, 6): no suitable image found.ĭid find: /usr/local/lib/libmyodbc5w.so: mach -o, but wrong architecture. I installed MySQL connector odbc-5.3.6-osx10.11-x86-64bit and created a DSN (server=localhost, user=root, password=*****,database=wsn_db).I installed iODBC driver manager 3.52.12.usr/local/lib/libmyodbc5a.so: mach-o, but wrong architectureĢ: In RODBC::odbcDriverConnect("DSN=wsn_mysql_5 UID=root PWD=****") : ERROR: state 00000, code 15509574, messageĭlopen(/usr/local/lib/libmyodbc5a.so, Gives this error: 1: In RODBC::odbcDriverConnect("DSN=wsn_mysql_5 UID=root PWD=****") : I am having problems accessing my MySQL database from R on mac (Mac OS X 10.11.2).