Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ERROR 08001 Authentication Violation

2 posts in General Discussion Last posting was on 2005-11-29 14:11:34.0Z
udayr Posted on 2005-11-29 11:20:59.0Z
Sender: 5f89.438c3963.1804289383@sybase.com
From: udayr@stcroixsystems.com
Newsgroups: ianywhere.public.general
Subject: ERROR 08001 Authentication Violation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <438c399b.5f8e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Nov 2005 03:20:59 -0800
X-Trace: forums-1-dub 1133263259 10.22.241.41 (29 Nov 2005 03:20:59 -0800)
X-Original-Trace: 29 Nov 2005 03:20:59 -0800, 10.22.241.41
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4996
Article PK: 17484

Hello,

We are using Sybase Adaptive Server Anywhere 8. Whenever our
application tries to UPDATE a record in a table we get the
below error. This problem is only coming on a particular
table. Can you please help us regarding this ? How to solve
this problem. Any help will be highly appreciated.

Thanks

Regards,
Uday



Authentication violation

--------------------------------------------------------------------------------
Item Value
SQLCODE -98
Constant SQLE_AUTHENTICATION_VIOLATION
SQLSTATE 08W21
Sybase error code 13620
ODBC 2 State 08001
ODBC 3 State 08001

Probable cause
You attempted to connect to a server which has been
authenticated for exclusive use with a specific application.


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2005-11-29 14:11:34.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051025)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ERROR 08001 Authentication Violation
References: <438c399b.5f8e.1681692777@sybase.com>
In-Reply-To: <438c399b.5f8e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <438c6196$1@forums-1-dub>
Date: 29 Nov 2005 06:11:34 -0800
X-Trace: forums-1-dub 1133273494 10.25.98.170 (29 Nov 2005 06:11:34 -0800)
X-Original-Trace: 29 Nov 2005 06:11:34 -0800, keating-dm20.sybase.com
Lines: 48
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4997
Article PK: 8638

Are you an OEM who is shipping ASA with your product? If so, please read
the "Adaptive Server Anywhere Authenticated Edition Read Me First"
documentation. It outlines how you need to configure your database and
connection to avoid this error. Please note, this software is not
generally used for development (save for testing) as your ability to
interact with the database will depend on whether the connection has
been authenticated.

If you are an end-user of a product that includes ASA, your access to
databases hosted on that engine is restricted. Ask your vendor for
details of that restriction but it is generally read-only access outside
of the vendor application.

Otherwise, you have overwritten your ASA install with an OEM version of
ASA. You may need to reinstall to correct.

BTW
The -98 will be reported for any unauthenticated connection. If this
error is reported only for a single table, you are either not updating
the other tables or your interaction with the other tables is on a
separate connection. The reason is that the authentication status is for
the connection. Note: The error will only occur if you perform an action
that violates the limitations i.e., read-only access.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************