problem - please help

I’ve tried everything over the last 2 days to be able to create and then connect a new database using Sybase Central.

I had a number of problems similar to other posts (eg “Fatal init could not load” and “can’t set up the repository server”). It’s been a horror.

Now I seem to have narrowed things down to the issues being to do with the creation of the new db.

If I create a new database (and don’t amend the confi file) I can still start Servoy and the servoy server starts up ok so I can use Servoy (ie no "can’t connect ..}

I can’t hiwever connect to that new database as I still get errors

Also, as soon as I add the line “database/testing.db” to the config file and restart Servoy, I get the errors and can’t start servoy. One error in the log file is:

“Database cannot be started – server must be upgraded to start “C:\Program Files\Servoy\database\testing.db” (capability 35 missing).”

So, it seems that there is an issue in the creation of the db. I’ve followed all the steps, reinstalled (clean) versions time and again on different machines etc etc etc

Any tips ?

Thanks in advance

Hi Greg,

Read through this thread it seems like it mirrors the problems that you are having and may hold the answer :

http://forum.servoy.com/viewtopic.php?t=2566

Cheers
Harry

Thanks. This appears to be exactly my problem.

I took the advice given in the thread and upgraded the appropriate files in my sybase_db folder. I also tried downgrading. I tried both these a number of times, interspersed with clean installs, reboots etc.

Still no luck.

The error I get on Servoy start up even with the upgraded sybase_db folder files is “Can’t connect to repository server .. blah blah .. connect refused:connect”

The sql engine starts ok and when I move my mouse over it, it says servoy_repository.

In the config log it says:

"Performance warning: Database file “C:\Program Files\Servoy\database\servoy_repository.db” etc etc

Any miracles would be appreciated.

The following is the error message I get when I try and connedct to a database. I’ve taken it from the .log file:

Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3212)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)
at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
… 10 more

Any advice etc would be greatly appreciated. Thanks

Thanks to Marc Norman who helped me offline. All’s ok after clean installs and upgrades to everything (Java and sybase files in servoy/sybase).

I’ve only been on the forum for a week or so and am in the process of evaluating Servoy. I’ve got to say, I’m very impressed with the Servoy team. The way issues are dealt with in the forum (and offline) as well as the pace of development / fixes /enhancements.

I’m used to forums where you NEVER hear a word from the development team / company staff. It’s great that the Servoy team are directly involved, it is a big plus for me in my decision-making process.

The whole thing has really got a buzz about it. Enthusiasm breeds enthusiasm.

Thanks again