Hi to all,
we would like to install and correctly connect Postgresql or MySQL on Servoy 3.1.3. Could someone give me exact instructions in order to this job?
Tanks in advance
Gianni Pinna
Hi Gianni,
Although it’s not exactly clear from your post but I will assume you already have MySQL/PostgreSQL set up and users and databases created.
To make Servoy connect you first need to put the MySQL/PostgreSQL JDBC drivers in the drivers folder in the Servoy folder.
You can get these from the following URL’s:
http://jdbc.postgresql.org/download.html
or
http://dev.mysql.com/downloads/connector/j/
Make sure you download a matching version.
After done this you launch Servoy Developer and go to the Preferences.
Here you select the ‘DB Servers’ tab panel.
Here you don’t use the New button but use the combo-box instead. Why? It will auto-fill the fields for you.
Select MySQL or PostgreSQL accordingly and fill in the connection name, username, password and database name (edit the database server url).
Click on OK and Servoy will try to make the connection.
If no errors pop up you are set to go.
Hope this helps.
If you need further help with MySQL, you can download a complete HowTo from my website: http://www.sintpro.com
Dear Robert,
tankYou for Yours specifications. I will execute them.
Sincerly.
Gianni Pinna
Dear Nicola,
tank You for Your howto which I’ll study if I’ll have problems.
Best rgrds
Gianni Pinna