Here's the full driver path: /Library/ODBC/FileMaker\ ODBC.bundle/Contents/MacOS/fmodbc.so
That folder will contain these two files: SetupToolTemplate fmodbc.so The driver should be installed here: /Library/ODBC/FileMaker\ ODBC.bundle/Contents/MacOS This provides for ODBC connectivity at the system level.
To install Homebrew, execute this command. But after installing unixodbc, you can also edit these ini files in a text editor without ODBC Manager. It manages the ini files described below. You've already verified that ODBC sharing is on in this particular FileMaker database. 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.
Filemaker pro mac for mac#
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).
0 kommentar(er)
