Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hi, when i register OEM Edition, the command dbisql -nogui -c "uid=dba;pwd=sql" myscript.sql will make response "Authentication violation, how can i fix this error.

Otherwise, when i used this command with dbisqlc utility,the exception did not occur?

asked 18 Aug '19, 23:51

tampv2's gravatar image

accept rate: 0%

DBISQL is self-authenticating. If a DBISQL connection is reporting a -98 error, it is either

  1. the database_authentication option has not be set in the database. The behaviour in this case is that there is no grace period for the connection.
  2. the dbisql being used is an initial major or minor version from some older versions of SQL Anywhere. I do not recall the affected versions but I recall 2 cases where the self authentication was not working correctly. Both cases were addressed in the first patch to the affected releases.

Please note that you cannot execute the database_authentication for a database that is running on an OEM edition. You either have to create the database on a non-OEM edition or provide an appropriately configured authenticate.sql that is used by create database (refer to the documentation for details).

We are aware of some embedded SQL usage that may not enforce authentication. This will likely explain why DBISQLC is not affected.

permanent link

answered 19 Aug '19, 06:01

Chris%20Keating's gravatar image

Chris Keating
accept rate: 32%

Thanks for answering! I tried placing the command below, but the same exception happened, which means that, when I execute the command below, perform the same response "Authentication violation".

SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=xxx;Application=xxx;Signature=xxx'

(19 Aug '19, 23:08) tampv2

That confirms (or at least strongly suggests) that the database_authentication option has not been set in the database. You cannot set that option on an OEM engine. The authenticate.sql file can be used to supply the database_authentication option when creating a database on an OEM engine.

(20 Aug '19, 07:56) Chris Keating
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: 18 Aug '19, 23:51

question was seen: 2,045 times

last updated: 20 Aug '19, 07:56