dsn configuration hangs attempting to acces FMP via ODBC
I want to connect to an FMP database via ODBC from an external windows program (Python)
I am running FMP12 have created a database, enabled Sharing (Odbc/Jdbc On)
selected All users access to mydb.fmp12
I then go to admin tools data sources(odbc) and create System DSN. When I get to screen asking which host to connect to
I have tried "localhost", 192.168.1.104(ip of same machine), 127.0.0.1 and then if I check the Connect to host to obtain names of ... and click next it hangs.
Alternatively I just go to next and try to enter database name (with and without .fmp12 suffix then Next and then enter either "Admin" or any other value including leaving it blank,and hit Test button it hangs.