Receiving an error when trying to look at the list of stored procedures
a
anonymous
started a topic
over 14 years ago
[This topic is migrated from our old forums. The original author name has been removed]
From the interface, when I try to view the list of stored procedures in a database, I receive the following error:
-------------------------------------------------
An error occurred while executing the database request for:
Adaptive Server Enterprise
Adaptive Server Enterprise/12.5.0.3/EBF 10972 ESD#1/P/Sun_svr4/OS 5.8/rel12503/1919/32-bit/FBO/Tue Mar 25 02:54:09 2003
jConnect (TM) for JDBC (TM)
jConnect (TM) for JDBC(TM)/6.05(Build 26023)/P/EBF14466/JDK14/Thu Mar 15 1:05:45 2007
Short message:
"cash4cast".dbo.sysobjects not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
The command that caused the problem:
select owner = user_name(uid), name, crdate "Creation Date"
from "cash4cast".dbo.sysobjects where type = 'P' order by name
Long Message:
"cash4cast".dbo.sysobjects not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Details:
Type: com.sybase.jdbc3.jdbc.SybSQLException
Error Code: 208
SQL State: 42000
System Information:
Product: DbVisualizer Personal 7.0.6
Build: #1499 (2010/04/21 08:23)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_18
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1
-----------------------------------------------------------
Basically what's happening is the database name is getting quotes around it and the select is failing. Anyone else seen this before? 6.5.5 works fine, but this is failing in 7.0.6.
[This reply is migrated from our old forums.] [Attachment has been removed.]
Re: Receiving an error when trying to look at the list of stored procedures
Eric,
Thanks for your post.
This is an issue in 7.0.6 for Sybase. The current workaround is that you save the attached file as:
DBVIS-HOME\resources\profiles\sybase-ase.xml
It will be fixed in the next version.
Best Regards
Roger
Roger Bjärevall
said
over 14 years ago
[This reply is migrated from our old forums.]
Re: Receiving an error when trying to look at the list of stored procedures
Hi,
This is now fixed in DbVisualizer 7.0.7.
Regards
Roger
anonymous