The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Okay, this is the dumb and dumbest question. I have been working hard writing code and not knowing what I am working with and I just came to a hard stop. Error -98. I can not create a user, add a table, etc... I downloaded the developer version of Sqlanywhere 10. That is the version that is existing on the DB I am using select to get data. I created a second db to write the data. I can read all day long, I can not write or add a user via sybase central sqlanywhere. I am trying to understand the "Authentication", I am not understanding it. Is it a purchased copy or is it a keyset I have to make between the db and the application?

This tells you I am really new to sybase. I don't know what it means. Please advise if I need to buy something or if it is a connection string.

Thanks, a direction is appreciated, really appreciated.

George

asked 06 Jun '12, 18:09

George's gravatar image

George
165101017
accept rate: 0%

edited 08 Jun '12, 03:22

Volker%20Barth's gravatar image

Volker Barth
29.3k287438645


The -98 error is only reported on an Authenticated Edition engine. Many commercial applications use the Authenticated Edition. Their applications get full access to the database engine and external connections get limited (generally read-only) access. What I suspect, given that you have installed the developer's edition, is that there is a third party application using the authenticated edition and that software is being run instead.

permanent link

answered 07 Jun '12, 08:51

Chris%20Keating's gravatar image

Chris Keating
2.4k1444
accept rate: 22%

Very possible. We purchased read access to the db from the company, I installed the developer sybase 10 (to match the version they use) to do my VB development. Your thoughts sound like they are correct. I think the next question, I am only doing a read from their db with a creation of a couple of proxy tables in MY separate db, what you describe is what I experience, but I am not understanding why it affects my separate DB, do I need to create a running service with the path to the developers dvscv/engine, I am using theirs in their location. c:/dir/dir/dbsrc and not c:program files/.... etc . Is it possible to have a developers version using my db and their authenticated version to access their db. Interaction is live.

(07 Jun '12, 11:50) George
Replies hidden

I suspect that the problem is related to how you are starting and/or connecting to your database.. If there is already an engine running, it is possible that your database is being loaded on that engine. The solution with be either : 1) Specifying an unique server name and specifying the START to use you engine install

or

2) Prestart your database on a server and connect it it rather than autostart. the database.

The approach you take will depend on your usage but I would consider option 2 in many cases.

Also, please note that the developer's edition is indented for development and you will need to obtain a license if this is used in production.

(07 Jun '12, 12:17) Chris Keating

If you are about to let two different database engines run on the same machine (i.e. the v10 OEM and your developer edition), I would strongly recommend to use a different major version for your own edition, say v11.0.1 or v12.0.1. More on this can be found in this FAQ:

Can I install two setups of the same major version on the same box? - where the official answer is: "NO" (at least under Windows).

(Note, it does not affect the situation of running two engines on two different boxes.)

(08 Jun '12, 03:20) Volker Barth

What is the initial version you used ?

Basically there exists two versions:

  • Full product (in many variants)
  • OEM edition which has some limitations, but also allows you to write to the DB

Is your login to the existing db perhaps restricted to readonly access ?

permanent link

answered 07 Jun '12, 08:20

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

Your answer
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:

×22
×18

question asked: 06 Jun '12, 18:09

question was seen: 948 times

last updated: 08 Jun '12, 03:22