SQL Anywhere 16.0.0.2158 - Authentication behavioral change!?

1

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

asked 01 Sep '15, 10:14

HBrener's gravatar image

HBrener
426●23●25●35
accept rate: 0%

One Answer:
active answersoldest answersnewest answerspopular answers
2

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
permanent link

answered 01 Sep '15, 10:53

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k●16●41
accept rate: 32%

Comment Text Removed
Comment Text Removed

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

(01 Sep '15, 16:52) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×258

question asked: 01 Sep '15, 10:14

question was seen: 1,789 times

last updated: 01 Sep '15, 16:52

Related questions

Spatial Data and ST_Transform

Allow SADIAGDIR to be set by DB server start-up parameters

dbvalid error -300 / index not match with table / rowcount

What can stop a database from being opened in read-only mode?

LOOP - variable not found

Is predicate push-down prevented for columns of a view used within a view using WINDOW functions?

Unable to obtain a SQL Anywhere 16 developer registration key

Unable to transform data from SRID 4326 to SRID 3347

Problem passing sasql_result as a parameter in PHP function

How can i create a remote server connection to mysql using SQL Anywhere 16