Run SQL-statement from client on FM-server
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.
- 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)?