SQL Configuration

Once the SQL Configuration link has been clicked in the admin section the page below will be displayed:

This page will show any SQL profile that has been set up including the three examples that come as default in MyConnection Server.

To use an MS SQL or MySQL the correct Java configuration needs to be installed. If this is not the case then the warning messages, shown by the number one above, will be shown on this page.

For MySQL see: http://dev.mysql.com/downloads/connector/j/5.1.html

For MS SQL see: http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en

To look at one of our example SQL profiles (number 2 above) then simply click the modify links next to an example number to see how SQL can be used with MyConnection Server.

To create a new SQL Profile click the link, as shown by the number 3 in the image above.

For more in depth information on SQL profiles and setting one up see our live demo section here.