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.

 

Thanks!

 

-JF

Outcomes