How to connect to SqlClient in UIPath, need example of ConnectionString and ProviderName

[dguleria (Deepak Guleria)]

HostName - dnd2016.database.windows.net
database - dnd
username - dnd123

[andrzej.kniola (Andrzej Knioła)]

I’d recommend checking out https://www.connectionstrings.com/ .

Regards.

[sushree.suravibuyan (Sushree Suravi Bhuyan)]

“Server=localhost;Port=3306;Uid=root;Pwd=1234;Database=lendors;” This connection string should help

[vikasrawat911 (Vikas Rawat)]

I am getting this error

"Keyword not supported: ‘port’. Source: Connect Exception Type: ArgumentException System.ArgumentException: Keyword not supported: ‘port’. "

[bvsprasad (sivaprasad)]

me too getting same issue(Connect : Keyword not supported: ‘port’.) can any body please help?