Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

We are using OEM Edition for SQL Anywhere(SA) (using database and connection authentication option setting). After upgrade to version from 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

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 through
  • SQL Anywhere through
  • SQL Anywhere through
permanent link

answered 01 Sep '15, 10:53

Mikel%20Rychliski's gravatar image

Mikel Rychliski
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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 01 Sep '15, 10:14

question was seen: 1,935 times

last updated: 01 Sep '15, 16:52