Servoy currently ships with 9.0.1, on the ianywhere download page you can still get 9.0.1 (the latest is 9.0.2). Get 9.0.1 for compatability with Servoy.
http://www.sybase.com/detail?id=1036185
First when starting Servoy you get:
- Code: Select all
Can't connect to the repository server specified in the application preferences.
java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException: Connection refused
Then in the sybase_log.txt you see:
- Code: Select all
E. 08/03 07:27:24. Database cannot be started -- server must be upgraded to start "/Applications/Servoy/database/contact_mgmt.db" (capability 32 missing).
This problem is being caused by creating databases by a newer version of ASA then the one Servoy runs on.
At this point in time Servoy ships with ASA 9.0.0 If you download the Sybase tools (Central et al) from the iAnywhere website they'll give you 9.0.1. The solution is to make sure you're engines have the same version. You can either upgrade your Servoy install to 9.0.1 or you can downgrade your sybase install to 9.0.0
To upgrade:
-Stop Servoy if it is running
-Stop ASA if it is running (on win right click on the SQL icon in the taskbar and choose close, on mac/linux kill the dbsrv9 process)
-Make a backup of your entire Servoy directory (so if the upgrade doesnt succeed you can go back quickly)
On Windows:
find the equivalent of all .exe and .dll files found in the sybase_db directory inside Servoy in the Sybase install (by default: C:\Program Files\Sybase\SQL Anywhere 9\win32) and replace the files in the sybase_db directory.
On Mac:
Replace all files of the files in sybase_db folder with their corresponding ones except charsets, sybase_log.txt and sybase.config. You can find the files in /Applications/SqlAnywhere9/System/ (in the lib, res and bin folders)
On Linux:
Replace all files of the files in sybase_db folder with their corresponding ones except charsets, sybase_log.txt and sybase.config. You can find the files in the directory you installed ASA into (in the lib, res and bin folders)
If you want to downgrade you can perform the opposite procedure. Upgrading however is recommended. If you downgrade you won't be able to open 9.0.1 databases and you'll have to recreate them.[/b]