|
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:
Can anybody advice? |
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: 04 Dec '19, 07:51
question was seen: 1,107 times
last updated: 04 Dec '19, 14:51
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?
> 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 :)