I have a windows server 2008 SP2 with filemaker server 15.
I would like to connect a table in excel via ODBC.
I downloaded the ODBC driver for filemaker and installed, both 32 and 64 bit - version 15.00.06.00
In "control panel" I go to ODBC and choose to create a new System DSN.
I try to connect from localhost, put a check on "connect and retreive database names" but when I hit on "next" nothing is showing.
If I go back and take off the chek, I can create the DSN leaving the Database fileld blank but then it ask me for some user and password. what I should put in there? if I use the console administrator password I get "[FileMaker][FileMaker] (802): Unable to open file"
Am I missing something?