Start a new topic

Receiving an error when trying to look at the list of stored procedures

[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
[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