Hi,
I am trying to set up an ODBC connection to a MS SQL database. I can set up the DSN on the client running FMPA 17 (Windows 10) 64-bit version, create the file locally, connect to the DSN and retrieve data. All works with no problem.
I then host the same file on Server 17, Windows Server 2016 on AWS. I can no longer connect to the SQL server when the file is hosted. I cannot even see the DSN created on my client machine that functioned perfectly before in a non hosted setup. Note that I am not trying to connect to FMS as an ODBC client, I am trying to connect my FMP client to a SQL server.
I have seen elsewhere on the forum that I may have to use a 32 bit DSN instead. I tried that but it is not compatible with my 64-bit FMPA, and also it still does not show up on the hosted version.
What am I missing?
When a file is hosted on FMS and you want to use ESS then your FMP client will only show the DSNs that are set up on the server, not the ones on the client. The whole point of ESS through a hosted file is that you wouldn't have create DSNs on each individual client's workstation.
And no: you don't need a 32-bit DSN and driver, FMS is completely 64-bit. You would only need a 32-bit DSN if you were working on a local file with FMP 32-bit.