Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

getting error after upgrading from sqlanywhere 7 to sqlanywhere 9

8 views
Skip to first unread message

narayanarao

unread,
Feb 3, 2005, 9:17:47 AM2/3/05
to
i'm using sybase sql server any where 7 and by using
dbsrv7.exe i'm able to create db.
it's working fine. no issues.
now i'm upgrading to sybase sql server any where 9 and by
using dbsrv9.exe i created
db. this time when i'm using sysindexes table of sybase i'm
getting
error as
Table name 'sysindexes' is ambiguous exception
com.sybase.jdbc2.jdbc.SybSQLException
because ASA Error -852: Table name 'sysindexes' is
ambiguous
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -852: Table
name 'sysindexes' is ambiguous
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1578)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1563)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:418)
at
com.cisco.nm.util.db.DBUtils.doesIndexExist(DBUtils.java:174)

why this is happening. any help is appreciated.

Glenn Paulley

unread,
Feb 3, 2005, 10:11:41 AM2/3/05
to
Look in the help index under SYSINDEXES..conflicting name.

Glenn

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

0 new messages