Forum Discussion

ilovechiku's avatar
ilovechiku
Contributor
9 years ago

SOAP UI 5.2.1 and database validations failing

   I have soap ui free version 5.2.1  iam using windows 10. Have the latest JRE 8.0 What am confused is what .jar file should i be using. It is giving me a error on connecting to the database at t...
kondasamy's avatar
kondasamy
Regular Contributor
9 years ago

I could able to connect to MS SQL server using the below connection string,

 

GroovyUtils.registerJdbcDriver( "com.microsoft.sqlserver.jdbc.SQLServerDriver" )
sql = Sql.newInstance("jdbc:sqlserver://$DB_URL;databaseName=$DB_NAME;user=$DB_LOGIN;password=$DB_PWD","com.microsoft.sqlserver.jdbc.SQLServerDriver")

Also the DB_URL should be in the format - 192.17.193.21:1433.

 

Thanks,

Kondasamy