Page History

...

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.

   Note
   title NOTE
   Even though a database is listed here, you must still install a driver in the drivers folder in order to connect to the database.

5.  Fill in the Server Name, User Name, Password, URL, and Driver for your database. You can find the correct values for the URL and Driver from your database documentation, or suggested values will be already entered if you selected your database in the New Server menu.

   Note
   title NOTE
   The user account should be of administrator level so you have full access to database objects in Servoy.

6. Save the tab by clicking the save button in the toolbar or using Ctrl-S to save the tab.
7. Your database should now appear in the Database Servers list.

...