My understanding is that Servoy includes a free version of ianywhere. In order to create a new table you need to download Sybase Central which is not in the Servoy installer. When I go to Sybase to get the Central application, it’s not clear as to what I’m supposed to get. I did download a copy of Sybase Central but I also got SQL Anywhere 10. It seems this is a trial version that I eventually while need to purchase? Is there a specific version of ianywhere that I need to have? Can I just use the Sybase Central to administer a different free version of ianywhere, and ignore SQL anywhere? I’m a bit confused out of the gate on this one. Thanks for any help.
Creating tables can just be done with Servoy, so no need to download other stuff for that.
If you rightclick a database server in the solution explorer, you’ll see a “Create table”-option in the context menu.
However if you want to download sybase central, you can use this link. You have to fill out a form, but as far as I know it is free.
My understanding is that Servoy includes a free version of ianywhere.
Not really. It is part of Servoy and we don’t have to pay extra for it but I would not call it free.
Also, you are allowed to use it in combination with any Servoy client. Once you use it in combination with something like php etc. you have to pay additionally.
When you don’t like iAnywhere (for whatever reason) you can use any database that has a jdbc driver for it.
I did download a copy of Sybase Central but I also got SQL Anywhere 10. It seems this is a trial version that I eventually while need to purchase?
No need to do that (see the above)
Is there a specific version of ianywhere that I need to have?
Best is to use the version distributed with Servoy, the rest you can ignore.
Can I just use the Sybase Central to administer a different free version of ianywhere, and ignore SQL anywhere?
Thanks for all the help Marcel. I guess I just ned to figure out how to make a new database server.
One more question, If I create a new solution on my computer, how do I get it on to the server? When I export it, I get a .servoy file. If I try to import it from developer on the server, it’s looking for an archive file.
Thanks,
I tried duplicating one since I thought that would be easiest but when I try to save it, it tell me there’s already one with those links. I’m not sure what to change since I don’t understand much of what I see there anyway. I’d just like to start off with a fresh database so I don’t mess up any of the examples.
Duplicate doesn’t create a new database, it just takes the details of an existing server to create something similar. “Create Sybase database” is the only functionality in Servoy that creates a new database and it is for sybase only. Otherwise you would have to create the database outside Servoy and then create a server (connection) in Servoy.
This error is due to the fact that C:\Program Files\Servoy\application_server\sybase_db\scripts is not in your temp windows environment variable. If you add that folder to temp variable it will work. This will be fixed in 4.1.1
Thanks for the reply.
Quick question, if I create another database on my development computer, export the solution then import it to my server, will it bring the new database with it, or will I need to create the new database on the server as well?
By the way, I’m using 4.1, where can I get “an intermediate release”?
BillB:
will it bring the new database with it, or will I need to create the new database on the server as well?
It’ll bring a database name with it. When you import solution it’ll check for the database name with imported solution. If it’ll not find database. It’ll give error server connection not found, So you need to create database connection before importing the solution.
BillB:
I’m using 4.1, where can I get “an intermediate release”?
Goto Servoy root directory and execute servoy_updater.bat file or goto command prompt and write : java -jar servoy_updater.jar
