At the risk of stating the obvious:
Check you are using latest FM version, and in particualr , the latest version of the Driver for that SQL db type (which is ??)
Is the SQL db version used a current version, and fully updated ?
If you are already using the same driver and SQL source successfully first step is to delete the DSN and start over.
Always good to ask the obvious!
Yes, I have the latest FM version and drivers. I did download fresh
ones, just to be sure.
And I did delete the driver and started over. Existing connections
continued to work well; new one failed again.
You have not answered what the database the ODBC source is (the exact version). FMP is still 32-bit so you do need the 32-bit driver for your database source.
You mention that you have other ESS sources already, I'm assuming that those are for other databases on other backends?
It's MySQL 5.5. It's hosted on GoDaddy. The other database, the one
that's working, is also on GoDaddy, but at another domain.
And, yes, I"m using the 32 bit drivers. Been down that road before. The
connections are that working use the same driver as the one I'm
attempting to use.