After following all the steps to create a new database I get the following error message at Servoy Startup:
java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException: Connection refused
After closing the error box nothing is available.
I know that I did something wrong, I just can’t figure it out.
Thanks for any assistance[/quote]
I assume you’re using Sybase ASA. I’m also going to assume you’re on Windows. I sometimes have trouble connecting to new ASA dbs too - it seems to be a little bit unstable in that area.
Here’s a checklist:
Have you looked in sybase_log.txt for any info about what’s causing the problem? Also look in .log.txt in the Servoy folder.
Did you remember to stop the repository server before restarting Servoy? Do this by right-clicking on the server icon in the system tray and selecting “Exit”.
Did you add your new db to the sybase.config file?
Are you connected to the new db from Sybase Central? You shouldn’t be.
Did you setup a new db server in the Servoy Preferences with correct username and password and correct db name?
As a last resort, you might try increasing the number of connection retries under the Designer tab of the Preferences window, but I doubt that’s the problem.
I am sorry i did not give more details in the begining.
Servoy version R2 2.2.5 with Sybase ASA on both a Mac and a Windows.
Mac with 10.4.5, Window with XP-Build 2600-Service pack 2.
This problem started on the Mac. I opened Sybase Central & created the new db. I updated the Sybase.config file. I exited Servoy. I turned off the repository using the activity monitor. Restarted Servoy, went to prefs and clicked on the DB servers tab then enter the new db name. When i clicked on the OK button i got the error message:
java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException: Connection refused
At that point i new something was wrong so i canceled the new connection and tried to open a db that had been worked on previously. It is no longer available. Nothing is available. Nothing works.
I attempted to open the logs. The Servoy logs show nothing. The Sybase log has the following:
E. 05/16 16:22:07. Could not open/read file: database/TWF_MailList.db
E. 05/16 16:36:19. Could not open/read file: database/TWF_MailList.db
E. 05/16 16:38:24. Could not open/read file: database/TWF_MailList.db
E. 05/16 16:56:07. Could not open/read file: database/TWF_MailList.db
E. 05/16 16:57:15. Could not open/read file: database/TWF_MailList.db
E. 05/16 17:01:32. Could not open/read file: database/TWF_MailList.db
E. 05/16 18:23:16. Could not open/read file: database/TWF_MailList.db
E. 05/17 07:04:45. Could not open/read file: database/TWF_MailList.db
E. 05/17 07:12:21. Could not open/read file: database/TWF_MailList.db
Each line aparently represents each ettempt to open Servoy.
After this i tried it on Windows. The exact same steps produced the same results. The Sybase log there reads"
Database cannot be started – server must be upgraded to start “C\Program Files\Servoy\database\TWFMailList.db” (capability 35 missing).
I don’t know if any of this helps, its just where i am at.
Thanks for your help.
Make sure you’ve added your database path to the “sybase.config” file. Also see: http://forum.servoy.com/viewtopic.php?t=2566
tommygill:
IDatabase cannot be started – server must be upgraded to start “C\Program Files\Servoy\database\TWFMailList.db” (capability 35 missing).
That means your windows version is still on iAnywhere 9.0.1. If you run a clean install of Servoy 2.2.5 you will also have iAnywhere 9.0.2, it looks like your database was created with 9.0.2, databases created with 9.0.2 cannot be opened using 9.0.1
Thanks for your help.