I would like to accomplish the following:
Add an AWS (Amazon web services) hosted sql2008 database as an external data source in filemaker.
For some reason this is proving to be quite challenging, grrrr.
I would like to note that I do not have any experience with ESS so I could be making rookie mistakes.
I need to import from the sql database to FM and the only way to do that is to add and external data source.
Steps I've taken so far.
1. Dowloaded the recommended ODBC manager.
2. installed the driver and
3. Added a new 'system dsn'
any ideas of where I should start trouble shooting.
I would much appreciate all/any ideas