SqlAnywhere 12- service started but stopped

sybase-sql-anywhere

I've been running my *db file on Windows 7 platform. Rrcently I have encountered a problem where I try to revoke the SqlAnywhere server but I received this error:

The Sql Anywhere- myserv service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

Kindly help.

Best Answer

If you are still having problems with this, the first place to look is in the Windows Application Events log - you should see the reason (eg manual shutdown requested) why the server was stopped.

You can also get the database engine to write its own console log to file with the

-o <filename>

server start up option - that may give you more detailed information.

It's important to check that your connections aren't specifying the AutoStop connection parameter or the Stop Database After Last Disconnect ODBC setting. This only applies if you are asking the connection to automatically start the database engine if it is not already running - NOT if you are running the database engine as a service.

Related Solutions

SQLAnywhere – How to Get List of Enabled/Disabled Features

You don't say which version of SQL Anywhere you are using but for v12.0.1 you can execute SELECT PROPERTY ( 'ServerEdition' ); The result is explained in the docs thus:

ServerEdition

Returns a space-separated list of words describing the database server type. Values include:
Evaluation
Developer 
Web 
Educational 
Standard 
Advanced 
Workgroup 
OEM 
Authenticated
If you have a separate license for any of the following features, then the appropriate string(s) are added to the license string that is returned:
HighAvailability   See SQL Anywhere high availability option. 
InMemory           See SQL Anywhere in-memory mode option. 
ECC                See SQL Anywhere security option. 
FIPS               See SQL Anywhere security option. 

You can get more help at the dedicated SQL Anywhere forum http://sqlanywhere-forum.sap.com/

SQLAnywhere Procedure Creation – How to Fix Failure on Creation of Procedure

The problem is you are mixing the CREATE FUNCTION syntax with that for CREATE PROCEDURE

This should work:

CREATE OR REPLACE PROCEDURE __generate_new_VSN(@oldVSN varchar(100), OUT @newVSN  varchar(100)) 
BEGIN
      RETURN '1'
END

the full syntax is here

Best Answer

Related Solutions

SQLAnywhere – How to Get List of Enabled/Disabled Features

ServerEdition

SQLAnywhere Procedure Creation – How to Fix Failure on Creation of Procedure

Related Question