cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Anywhere 16.0.0.2158 - Authentication behavioral change!?

2,186

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!?

Accepted Solutions (0)

Answers (1)

Answers (1)

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
Contributor
0 Kudos

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