I know this is a newbie question, so I’m sorry in advance for asking: Could somebody give me a walk-through so I could use Servoy Developer to modify a solution that was on my laptop, but that now resides on another computer (ie. in a different repository)? I tried modifying the parameters of the DB Servers connection to point to the correct IP address of the distant server, but it doesn’t work. Do I need to change my servoy.config file also? What should it look like? A step by step procedure would be much appreciated. I looked everywhere in the documentation, but didn’t find anything that clearly addressed this situation.
Hi Ben, step-by-step is a little too much imho but I can give you some pointers:
when your db is on another system you should (still) make sure your db server is running;
you need to edit the Servoy properties file but do so via the preferences panel to be sure you do it the right way. It will also give you feedback that it is running.
other system can also mean ‘potential firewall issues’.
In general, running your db’s on a remote server should be no different than running on a local machine.
You need to point all the DB connections that are used for that solution to the remote database server.
And don’t forget to change your repository connection as well
After this you relaunch Developer and you are set to go.
Thank you guys for responding. I’m getting closer to my answer: on my MacIntel laptop, I pointed the repository_server and my other db_server to my Servoy server (with the help of the Preferences panel) using the following address structure:
However, my solution hosted on the server machine is not listed when I open up Developer on my laptop, which leads me to beleive that I’m missing something. In the laptop’s sybase.config file, the entries are all on one line and begin with ‘database/[name_of_db]’. What should I put in there so that my remote solution appears on the list when I’m accessing it from my laptop? Is there some sort of network path that should go here? I would think so, because even though my repository points to my server machine, when I delete a solution from my laptop, it does not affect what solutions are installed on the server.
The Http, RMI and Sybase ports all point to my server from my router. I repeatedly started and stopped the Servoy service on my laptop, as per the instructions, but to no avail.
Sorry for pestering you about this, but I would really like this to work…
When I change the localhost to the IP address of my remote machine, eg the remotr_server,
it just comes up with an error. I have set-up a DMZ on my remote machine, so i cant think what the issue might be. I am behind a firewall at this end, but i cant think that that would make a difference as the other Servoy stuff when accessing that server works fine from a client here?
jdbc:sybase:Tds:[ip address of my remote server]:2638?ServiceName=servoy_repository&CHARSET=utf8
When your remote database is running you can simply add it as a new database connection to you Servoy developer. It will then accept it when available or deny it when you made a mistake or the db doesn’t run. That is all there is to it…
Thanks for that, I am not quite clear (forgive me i am a beginner to Servoy).
Does that apply to a solution that i am hosting on Servoy at home that i want to edit in developer mode at the office?
What do i do set-up a database connection similar to the reporistory one on my office machine, but point it to what ?the solution name on my home machine? instead of servoy_repository? using a similar set-up to the servoy_repository server?
Hi, when I completely answer you I am afraid I am going to rewrite the documenation because… You are mixing up two thing. There is a solution and there are the database connections.
A solution is what you create for the enduser to do whatever needs to be done. It is stored in the repository.
The repository and possibly the database(s) you use to store the user data are databases defined in the preferences under database servers.
The third thing to consider here that defining a database in Servoy does not mean that you have the database at hand. Basically Servoy only uses a database but does not create it. Although this might seem different because they ship with SQLAnywhere they have nothing to do with the creation of databases…
These two are really different but if I were you I would read the documentation (again) it should make it much more clear to you.
As with everything. It is not so difficult once you know how to use it.
As Marcel has said a step-by-step guide is really beyong the scope of the Forum. However this is the sequence I would suggest to get you started:
1 - Setup test.db on Developer computer
2 - Start developing “TestSolution” on Developer computer
3 - File / Repository / Export to File “TestSolution” - tick ‘Export solution data’ and ‘Create new Release’
4 - On Home computer setup an empty test.db with just the PK field (give this field the same name as PK field on Developer computer
5 - Re-start Sybase and Servoy Server on Home computer and ensure that ports 1099 and 8080 are allowed on Firewall
6 - From Developer computer use browser to access http://homeIP:8080/servoy-admin
7 - Got to ‘Solutions’ and select ‘Import a Solution’ - select “TestSolution” -the one you just saved - and leave all default settings but tick ‘Import solution sample data’
8 - During the import Servoy will create all new fields, import the data, and all the solution logic
9 - You can now access the solution from any computer (subject to having sufficient licenses) as a Rich Client via http://homeIP:8080/servoy-client/servoy … ution.jnlp - this will put an icon on your desktop for subsequent access
Continue developing on Developer computer and repeat steps 3 - 6 - 7 as often as you want to update the Home Server. On subsequent updates do not import data - this enables you to test fully on the Developer computer without touching the real data on Home computer.
It’s well worth investing in a set of manuals to fill in the detail I have necessarily omited from the list above.