AnsweredAssumed Answered

Setting up FMP 14 as a datasource for R

Question asked by jfrench on Sep 20, 2016
Latest reply on Oct 25, 2016 by astelix

Hello All,


I am trying to use FMP 14 as a data source in R. I have ROBDC installed and active, and the fmp_xdbc listener is active. I have set my DSN up and turned on ODBC sharing in FMP.


When I run the command to open the channel:


channel <- odbcDriverConnect(connection = 'MR_DSN')


I receive the following errors:


Warning messages:
1: In odbcDriverConnect(connection = "MR_DSN") :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2: In odbcDriverConnect(connection = "MR_DSN") :
[RODBC] ERROR: state 01S00, code 0, message [Microsoft][ODBC Driver Manager] Invalid connection string attribute
3: In odbcDriverConnect(connection = "MR_DSN") : ODBC connection failed


I have made sure the listener process is active and functioning, but nothing works. Has anyone had success setting this up? Any help would be greatly appreciated.