We are using sqlanywhere 17 with Embarcadero Delphi under Windows and connect to the database with NativDB components (Liodden Data).

This works very good.

Recently I tried to use the odbc sqlanywhere 17 driver to get rid of third party components.

Several problems came up:

  • Queries with large Data Amount run into a "Out of Memory" Exception
  • To use DML - update/insert/delete commands or DDL- commands like create table an authentication to the database is required. I send this authentication with a "set option" command and it works, but this authentication seems to be lost after a while and the Error -98 "Authentication violation(08W21) comes up.

Can anybody advice?

asked 04 Dec '19, 07:51

maba7638's gravatar image

maba7638
11334
accept rate: 0%

1

The error -98 Authentication Violation is due to you running an OEM edition of SQL Anywhere. If you are the developer of the OEM product that embeds SQL Anywhere as the database, you will need to authenticate the connection otherwise the connection becomes readonly after 30s. If you are an end user of a product that embeds SQL Anywhere OEM edition, you only permitted read-only access to the database outside of the OEM application. My guess is that the NativDB supplied the authentication information in some way outside of the application code.

What specifically reported the Out of Memory? Can you provide the error code that is reported?

(04 Dec '19, 11:36) Chris Keating
Comment Text Removed

> this authentication seems to be lost after a while

Is it possible there are multiple connections being made, and not all of them are executing SET TEMPORARY OPTION connection_authentication?

Is it possible that NativeDB was taking care of authentication for you? . . . no, wait, Chris said the same thing :)

(04 Dec '19, 14:49) Breck Carter
Be the first one to answer this question!
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:

×145
×3

question asked: 04 Dec '19, 07:51

question was seen: 1,211 times

last updated: 04 Dec '19, 14:51