Data Source URL String Having SQL Server Instance

Data Source URL String Having SQL Server Instance : 

In case your database connection string has a server instance please follow the following string format while creating the data source profile.

SQL :   

jdbc:jtds:sqlserver://10.0.0.85;instance=SQLEXPRESS;databasename=test

 OR 

jdbc:jtds:sqlserver://10.223.3.16:1433/RDS;instance=INSTANCE2

MYSQL :   

jdbc:mysql://127.0.0.1:3306/test

Oracle :  

jdbc:oracle:thin:@10.0.0.7:1521:jmc

Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten Version 5.x you may be using.