SQL Anywhere 16.0.0.2158 - Authentication behavioral change!?

[former_SQLA_member1694890]

We are using OEM Edition for SQL Anywhere(SA) (using database and connection authentication option setting). After upgrade to version 16.0.0.2158 from 16.0.0.2018(2095) we found out Sybase Central and DBISQL applications working with read-only access connection. It is first time we see this behavioral since SA 12 version. After apply SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='...' statement DBISQL application allow as make changes in DB; for Sybase Central we didn't find how to set this connection option. The question - is it change behavioral or some bug!?

[former_SQLA_member1694878]

This is a bug in some versions of SQL Anywhere that affects the built in administration tools.

The bug was introduced by CR#785757 and fixed in CR#788197, the affected versions are:

• SQL Anywhere 12.0.1.4294 through 12.0.1.4307
• SQL Anywhere 16.0.0.2156 through 16.0.0.2170
• SQL Anywhere 17.0.0.1207 through 17.0.0.1237

[VolkerBarth]

So a workaround might be to add an "InitString=SET TEMPORARY OPTION CONNECTION_AUTHENTICATION=..." to the connection string for the administration tools?