I am migrating our database from version 9 to version 16.
It seems there is something wrong with the authentication to the remote servers from SQL Anywhere 16.
I created a test case of creating a brand new Remote Server on both platforms ( v9 and v16 ).
On v9, each time I attempted the connection, I got an appropriate message from the MySQL ODBC driver about invalid login, until I supplied the correct Remote MySQL login and password.
However, on v16, whether I did or did NOT specify the remote SQL authentication, it reported the same error that 'dbo@....' failed to connect. The Remote login information is being ignored.
I have two sets of screen shots to demonstrate this - I hope I can attach them to my question!
Just a very wild guess:
The new v16 "extern_login_credentials" option may make a difference here. To cite:
In your case, it seems v9 and v16 behave differently in the way which user is used to connect remotely.
For the details, Karim has explained this in this FAQ - and note, a brand-new v16 db and a migrated v16 db seem to behave differently by default: