Solved

Sybase ODBC errror: Triggers and Procedures not supported in runtime server

Posted on 2004-08-25
22
919 Views
Last Modified: 2011-09-20
Hi I hope someone has seen this before:

We are using a tried and tested application which works on a number of operating systems including XP.  The application is VB6 with a Sybase Adaptive Server Anywhere version 6.0.3 backend database which can reside locally or the db can run on a server as a server.  In this case it is has the database locally.  At first I noticed that the XP was Professional version with automatic updates switched on a XP SP2 loaded.  Therefore I thought this might be the problem.  However when I switched off the XP Firewall and uninstalled SP2 the problem persists.  The error is Sybase ODBC errror: Triggers and Procedures not supported in runtime server.  Can someone please help?

Thanks

Dave
0
Comment
Question by:barnesd1
  • 8
  • 6
  • 5
  • +2
22 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 11891929
From ASA Error Messages:

http://sybooks.sybase.com/onlinebooks/group-sas/awg0800e/dberen8/@Generic__BookTextView/42413

You attempted to call a stored procedure or have modified a row in a table on which a trigger is defined and you are using the runtime server. Triggers and stored procedures are not supported in the runtime server. You must be running the full server to use these features.

Leon
0
 
LVL 4

Author Comment

by:barnesd1
ID: 11891980
Leon

Yes I found this message on the internet as well.  It doesn't explain why every other installation of the same product works fine.  I need to find out if there is a cause for this error to occur because of a bad installation, clash with some other product or service pack, etc.  It is not a code issue.
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 11892033
Are you saying that you have a local ASA db instal on a different operating system and it is working?

Leon
0
 
LVL 4

Author Comment

by:barnesd1
ID: 11892102
Yes it is local.  Also other installs are working fine on NT4, 2000, 98 and XP.
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 11892158
Is it a particular procedure(s) which is not working or no database calls can be made?  At what point are you getting an error?

Leon
0
 
LVL 4

Author Comment

by:barnesd1
ID: 11892225
I appears to be failing when it is calling a stored procedure.  I am remote to this installation so its not easy to investigate.  Could security patches be causing this I wonder?
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 11892346
According to everything I know it is running the way it should.  In order to get this to run the way you want it to run you would need to instal the ASA as a server on the local machine.

Leon
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 11941963
I am aware that Sybase has an ASA database called "Ultralite" which is NOT the ull blown ASA.
Ultralite does not support triggers / procedures

Are you sure someone didn't install Ultralite by mistake ?
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 11942023
Another thought:

Microsoft also have a "free" lightweight database (can't think what it is called) that might have been auto installed and could be interfering somehow.
It also does not support triggers / procedures
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 11942242
Microsoft has a free database called MSDE and it does support store procedures.

http://www.microsoft.com/sql/msde/default.asp

The only time I heard of SQL Server interfering with Sybase was then both clients were installed on the same machine and that was for SQL Server 6.5 vs. Sybase 11 and the problem was that an application was trying to use the DB library instead of the CT library.

Leon
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 6

Expert Comment

by:ChrisKing
ID: 11942715
no, not the MSDE (it does support procs/triggers), I am talking about a "lightweight database", can even be installed on WinCE devices
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 11943590
There are versions of Access and SQL Server which can be installed on WinCE, but I never heard of these being installed on anything else but WinCE.

Leon
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 11947956
doesn't matter, we are getting a bit off the track now.

barnesd1
can you post the output of SELECT @@version
0
 
LVL 4

Author Comment

by:barnesd1
ID: 11950475
@@version = 6.0.3.2747
0
 
LVL 4

Author Comment

by:barnesd1
ID: 12015225
The solution to this was actually a simple conflict.  The customer was running Ghost and this was causing this unlikely error message.
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 12016898
well done for tracking that one down!
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 12017015
I guess this is the time to close the question.  Please select one, or more, of the posted responses as an answer, if you feel that we were helpful, or place a request in the Community Support area asking for a refund if you believe you answered this question by yourself.

Leon
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 12017091
I do believe that barnesd1 did indeed answer this one theirself
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 12018684
No objections,

Leon
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 12056737
Closed, 500 points refunded.
CetusMOD
Community Support Moderator
0
 
LVL 1

Expert Comment

by:suryadip
ID: 12132857
Hello Dave,

I have the answer with me regarding your issue.

The reason you are getting the above error is because you are using the runtime standalone server.

So if you search the directory in which this standalone sybase is installed you will find rteng*.exe which is runtime engine and which doesnt support Stored Procedures And Triggers.

Instead you need to install dbeng*.exe file which contains the database engine which can process the Stored procedure and Triggers. Again writing the Stored procedure in ASA and ASE is slightly different. so you may have to resolve those issues as well.

Hope this solves the above problem. Please note that it is not an Operating System Issue.

--- Suryadip
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A procedure for exporting installed hotfix details of remote computers using powershell
A Short Story about the Best File Recovery Software – Acronis True Image 2017
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now