I am using filemaker server 9 advanced on windows XP. I have a filemaker file that contains a MySQL shadow table. The ODBC connection is done on filemaker server. All connects well and I have the correct username and password to connect to the MySQL data source. And in the filemaker file the datasource is set with the correct username and password.

When I open my published filemaker file and go to a layout for the shadow table it prompts me for a name and password for the ODBC data source. I have tried every combo of password/username to no avail. If i just press OK with no username and password it just connects anyway.

I only have one ODBC datasource and I have none set up on the client machine. I have tried every kind of username/password combo for the server, MySQL, the filemaker file, the client machine....

Strange.

My guess would be that there is still some anonymous access allowed, that is why you can hit ok and it will still connect.

When you set up the datasource to MySQL, did you check the box to "Specify username and password (applies to all users)" option or the "Prompt user for user name and password" option?

Edited October 18, 200718 yr by Guest