Me, too. Hope you get a detailed and clear response.
I haven't had the need for ODBC in a long time, but find myself in a similar situation. Have you searched about whether the other machine requires OBDC driver[s] as well?
dirk van Looij:
Thank you for your post.
"mps1773" has the correct assumption. The ODBC driver will also be needed on the machine that is getting the data. Therefore, make sure the client machine is also set up with driver so it can see the database on the remote server.
Hi dirk van Looij,
I just wanted to add another troubleshooting step to try.
I'm posting under the following assumptions but please correct me if I'm wrong:
A. The installation is on a Windows machine ("I've tried it.. on a different PC")
B. The issue = The System DSN pointing to MySQL does not appear when adding a data source in the File > Manage > Database > Relationships tab > Add ODBC Data Source window or the File > Manage > External Data Sources window
Please verify the following:
1. On the FileMaker Server machine, Go to Administrative Tools > Right click on Data Sources (ODBC) i.e. the ODBC Administrator > Properties
Look at the target path of the ODBC Administrator. Is it launching the file ODBCad32.exe?
If not, we're probably using the 64 bit version (not tested or certified) located by default in the Windows > SysWow64 folder. To get the 32 bit version, walk to:
[DriveLetter] > Windows folder > System32 folder > ODBCad32.exe file
You can copy the ODBCad32.exe file into the SysWow64 folder and then set the path to this file as the default ODBC Administrator path.
Try creating a System DSN in the 32 bit version by launching the ODBCad32.exe file and verify if it will now appear in your list of ODBC data sources while in FileMaker.
Hope this helps.
I also have the same problem. I followed the steps above but still not working.
Filemaker 11 Advanced Server is hosted on a Windows 2008 R2 server. MySQL ODBC version is 5.10.. There are windows and mac workstations connected to the server.
Original installation was on a Mac OSX server and there was no problem with regards to ODBC and MySQL connection. We moved the Filemaker Server to a windows machine to make use of the "Single Sign On" capability of Filemaker. Won't work on Mac servers.
everybody, I figured it out.
For FMS advanced 11 I installed MYsql ODBC 5.1 to connect with MYsql 3.51.
Further I installed a FM pro version on the same server as FMS advanced.
I stopped the database on the server and opened the database in FM pro.
In FM pro I build/made the conenctions, via scripts (imports SQL data) and via SQL tables build in the database.
This I tested it all in FM pro on the server and it worked.
Then I started in the FMS advanced the database again and scheduled the SQLimport scripts on the FMS.
since than it worked.