The setup of ODBC can be rather complicated since several software components with multiple versions are involved. I've had the same error in R and therefore I think there's a good chance that this your issue. Here are some imortant troubleshooting steps for MacOS. I'm not tied to RODBC, but I do need a solution that works for Mac OS. However, you can see that the driver is there:įinally, I've unsuccessfully tried using these (and other) references to resolve this issue: Which returns the following error: ERROR: state 01000, code 0, message Can't open lib 'FileMaker ODBC' : file not foundODBC connection failed Which returns the following error: ERROR: state IM002, code 0, message Data source name not found, and no default driver specifiedODBC connection failedĪND constr <- paste('driver=',įm_connection <- odbcDriverConnect(constr) Unsuccessfully attempted to connect to the DSN in RStudio in the following two ways: fm_connection <- odbcConnect(dsn='test_r', uid='Admin', pwd='password') Successfully tested the connection to test_r I'm trying to create the connection using RODBC (1.3-15).Ĭreated a toy FM Pro database for testingįollowed these instructions for creating a DSNĬreated a DSN for my toy FM Pro database called test_r I'm trying to create a connection between R (3.3.3) Using RStudio (1.0.143) and Filemaker Pro Advanced 15 (15.0.3.305).

Filemaker pro 15 mac