Port in invalid when trying to connect to the database

Product Forums Katalon Studio
#1

Hi All,

I am getting this error when trying to connect to the database:
com.microsoft.sqlserver.jdbc.SQLServerException: The port number sqlserver://10.0.0.191:1433 is not valid.

This is how i am calling my method statement:

CustomKeywords.‘databaseconnection.FicaEasyEquities.connectDB’(‘jdbc:sqlserver://10.0.0.195:1433;databaseName=GT247data’, ‘equities’,

'eq1t13s', 'com.sqlserver.jdbc.Driver')

This is how i wrote my Keywords:

@Keyword

public connection(String url, String user, String password, String DriverClassName){

def sqlconnection = Sql.newInstance(url, user, password, DriverClassName)

}

_am not sure what i did wrong there.
_
Thanks,

#2

Hello,
since 1433 is default port, try to not use it in your connection string or try use

jdbc:sqlserver://10.0.0.195\GT247data:1433