0 Replies Latest reply on May 27, 2014 1:31 PM by EricLarsen

    Run SQL-statement from client on FM-server

    EricLarsen

      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!