ODBC Data source not visable (not systWOW issue)
I'm attempting to add a recently configured ODBC data source to the relationship graph. When I try to locate the ODBC data source, it is not present in the list (other, older sources are present in this list). However, I'm able to use the ODBC driver within a script via "Import Records" step.
Any thoughts on what could be the problem?
Edit: I'm currently running FM11, latest version.
Thanks for your help in advance!
ESS (External SQL Source) is not possible with all ODBC data sources. For those that it is not, you can't set up a shadow table to refer to it, you can only import data from that source and then use the Execute SQL script step to push data back to it.