Running 3.5 and 3.1 on one PC

Classic Servoy
1

Is it possible to install Servoy 3.5 on the same system as where I use servoy 3.1-sybase 9 now?
If yes, how can I do this?

2

Check this post http://tinyurl.com/3aqda7 .

I haven’t done is before but they have.

3

Is this to work with developer or client.

When you do this with developer I remember to have posted a tip about it on Servoy Magazine.
It comes down to, in this case, using 2 different repositories (different names) in the same database.
Have run such a setup for years…

4

Yes, perfectly possible to run multiple Servoy instances on the same machine at the same time:

  • Install them in separate directories
  • Make sure Server Developer/Servoy server runs on a unique HTTP port (standard 8080, so consequtive environemnts can run on 8081,8082 etc)
    Make sure each database that is started has a unique name or port
  • Make sure each environment points to the right database

Those are the high level steps that should get you going

Paul

5

Hmmm okay,

Earlier we got problems with the services. I’ll try it soon!

6

On the same note, would there be an issue when I would use iAnywhere 10 with Servoy 2.2, 3.1 and 3.5?

7

That was also my next question.

If it works properly, we can just begin with using sybase 10 and running servoy 3.1 on it. Later we can go to servoy 3.5.

8

sure, why not? To Servoy, a database is just a database… :D

But… :(

Sybase changed a default setting in the database when they moved from version 9 to 10. If you leave this setting to it’s default value in Sybase 10, import of sample data might fail, where before they would succeed.

In Servoy 3.5 we make sure this changed Sybase setting doesn’t cause an issue, but if you want to run earlier versions of Servoy on Sybase 10, you need to alter this setting yourself. For this you have 2 options:
1: At database creation time
2: altering the setting on an existing database using an admin tool (you could even run this through the RawSQL plugin of Servoy :) )

The setting I’m talking about is “STRING_RTRUNCATION”. In Sybase 10 the default value is “ON” whereas in earlier versions of Sybase, the default setting was “OFF”. So, in order to let earlier servoy versions work properly with sybase 10, you have to set STRING_RTRUNCATION = OFF

How/when to set this during database creation probably depends how you create the database. I know it’s somewhere available when you create a new database using Sybase Central. you need to do some digging yourself here.

If you have an existing Sybase 10 DB that you want to use with earlier servoy versions than 3.5, you can execute the following statement at the DB to alter the setting:

SET OPTION DBA.STRING_RTRUNCATION = OFF

Note: Offcourse you need to fire this statement at all your Sybase 10 databases!!!

You can retrieve the setting for a specific database using the following SQL:

select * from sysoptions where "option" = 'string_rtruncation'

Hope this helps,

Paul

9

Great, I knew there was something :)

Thanks Paul!