AnsweredAssumed Answered

Run SQL-statement from client on FM-server

Question asked by EricLarsen on May 27, 2014

Title

Run SQL-statement from client on FM-server

Post

     Hi,

     I'm trying to export data from FM Pro to an MSSQL-server.

     The first thing I tried was to add the MSSQL-server as a OBDC connection on the client. This works as planned except for two things:

     - I'll be forced to setup this connection for every single client.

     - I couldn't get the HTML5 version to work with this connection.  

     Questions:

     - Is it possible to setup the OBDC-connection on the server instead? If yes, how do I do that so it's reachable from the client?

     - How do I make calls (run SQL-statements) from the client to this OBDC connection (server)?

     Thanks!

Outcomes