![]() ![]() Should contain these files: FileMaker ODBC.bundle odbc.ini odbcinst.iniĪdditionally, the unixodbc should contain only the latest version. 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |