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
426212333
accept rate: 0%


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.1k1641
accept rate: 30%

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

Question tags:

×203

question asked: 01 Sep '15, 10:14

question was seen: 506 times

last updated: 01 Sep '15, 16:52