Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Authentication error
18 views
Skip to first unread message
Chance
Oct 8, 2004, 5:43:16 AM10/8/04
to
Hi,
I am trying to upgrade a 5.0 database to 9.0. In particular, 9.01 build
1751. I need to do an unload but first I need to drop this view. However,
everytime I run this command I get an authentication error. Can someone tell
me why this is happening and a way to get around it? I was under the
impression that the command line tools were self-authenticating. No?
I am trying to upgrade a 5.0 database to 9.0. In particular, 9.01 build
1751. I need to do an unload but first I need to drop this view. However,
everytime I run this command I get an authentication error. Can someone tell
me why this is happening and a way to get around it? I was under the
impression that the command line tools were self-authenticating. No?
C:\Program Files\Sybase\SQL Anywhere 9\scripts>dbisql -c
"uid=dba;pwd=sql;dsn=bl
wmed" IF EXISTS (SELECT * FROM sys.sysviews WHERE viewname =
'v_cat_summary') TH
EN drop view group1.v_cat_summary; END IF;
Could not execute statement.
Authentication violation
SQLCODE=-98, ODBC 3 State="08001"
Line 1, column 1
IF EXISTS (SELECT * FROM sys.sysviews WHERE viewname = 'v_cat_summary')
THEN d
rop view group1.v_cat_summary; END IF
Press ENTER to continue...
Nick Elson
Oct 11, 2004, 5:32:56 PM10/11/04
to
If you are getting a true Authentication error, you have
a restricted usage product and you may need the assistance
of the vendor who installed that as part of their product.
a restricted usage product and you may need the assistance
of the vendor who installed that as part of their product.
If it is the version 5 product that is authenticated, you should
be able to unload that with the version 9.0.1 product [again
assuming that is not also authenticated]. Or visa versa.
"Chance" <cha...@booklog.com> wrote in message
news:41666134$1@forums-1-dub...
0 new messages