|
Hi I have connected sa_sql(sql anywhere) database with one of the application. I am facing one issue while inserting data into a table. Everything working fine but sometime am getting "Authentication violation" error. This issue will be gone after couple of minutes. This is happening in every insertion. Any help on this issue? |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 17 Apr '17, 08:02
question was seen: 5,114 times
last updated: 18 Apr '17, 02:46
Normally this indicates you need to contact the vendor/author of your application. An "Authentication violation" error indicates you are working with the OEM edition of the SQL Anywhere software and your connections are not authenticating correctly. The authentication mechanism is not an intermittent feature so something in the usage must be violating the requirements of how you must use the software.
Does the application use several connections? AFAIK unauthenticated connections have a "grace period" of 30 seconds before the restrictions will take place, so your initial DML statements may work and further DML will fail... - If new connections are established, they will have another "grace period" but again, further attempts should be doomed to fail.