I created my first Filemaker Database that connects to an ODBC datasource. All was working perfectly until I wanted to share the filemaker database by uploading on FM Server. Now when I access the database, it prompts me for a login to my ODBC connection and then doesn't accept my credentials.
I am unclear why I am being prompted ... when I set up the odbc connection, I chose to "specify user name and password" in the authentication section so that users would not be prompted.I also made sure that all privelege sets had the "access via odbc/jdbc (fmxdbc)" selected.
When I was running the database locally, it connected just fine, without prompting. Only after uploading the database to the server am I having this problem.
I would greatly appreciate any guidance - it feels as if I am just missing one little switch to turn everything on.
FM Pro 12.0v2
FM Server 184.108.40.2067