Thank you for your post.
There is nothing you are doing wrong. You cannot link to an ESS/SQL database in a runtime solution.
Can i as the reason for this?
This is a pretty severe limitation on the apps you can build with FM 9.
Is this something we might see chnaged/improved in the future?
We have no control where the external files are located. If it was implemented and the solution was taken to another location, the solution would display an error, and users would call us, and we're left trying to determine/guess what file it is looking for.
It has been brought up before. The best place to enter this suggestion is:
The web form asks several questions that only you can answer. Otherwise, I would do it for you.