Page History

Almost all Servoy applications utilize a database to store user data and application metadata.  Servoy can connect to any database that has a JDBC driver available. Servoy provides a database, Sybase SQL Anywhere, for you if you do not already have a database management system (DBMS).

Creating a New Database in Sybase SQL Anywhere

In Servoy Developer, you may create a new SQL Anywhere database from the Solution Explorer tree.

...

1. Determine the JDBC driver required for making connections to your database.  You can find the proper driver normally from the DBMS manufacturer/documentation; another source that may help is the Servoy Forum as other developers have possibly used your database with Servoy.
2. Install the driver by placing the .jar file in the application_server/drivers folder in your Servoy installation folder.
3. Restart Servoy Developer.
4. Create a new Database Server connection by right clicking on Database Servers node (under Resources) and selecting New Server.  A submenu will provide choices of different popular database choices that will fill in some of the connection information to make setup easier, or you may choose empty.
5.   Fill in the Server Name, User Name, Password,

It is best practice to create your data model (tables, primary keys, foreign keys, and fields)