Apologies for posting here, I know I've read an article from FMI on this, but I can't for the life of me find it.
I've got a client running FMS13 on a Windows Server. They have a FMP solution that they want to be able to communicate with a MS SQL2008 database. I've configured up a FMP13 client machine with the Actual Technologies ODBC driver and everything works fine, but how do I get this to work on the server? Surely I can just configure the ODBC connection on the server, and then I don't have to configure the ODBC driver on every client machine, right? If I want to have scheduled server-side scripts (which I do) to run which will work on the data in the SQL database, surely everything has to be configured server side anyway?
Do I even need an ODBC driver on the server, if it's running Windows Server 2008r2 or whatever? Doesn't that have built in MS SQL ODB Connectivity?
Cheers in advance for any help on this!