Database Connection issue

Hi Guys

While making a DB connection I am giving the DB connection string as below

“;uid=“wbsrt”;pwd= com56”

From below error message i can understand it is because of User id (uid=“wbsrt”) in quotes so RPA is assuming that DB connection string ends up to this “;uid=” skipping the remaining portion wbsrt";pwd= com56".

Can you please guide us on this

Error Message : {
“message”: “;uid=“wbsrt”;pwd=com56”,
“level”: “Information”,
“timeStamp”: “07:42:01”,
“processVersion”: “1.0.6799.9399”,
“fileName”: “Main”,
“jobId”: “3a157ae0-5bb6-4a32-b161-e62e970ac73c”,
“robotName”: “CABLE\KM200”


Hi @Kamesh,

in the DBConnection activity we have to configure the connection in this way,

“Data Source=Servername;Initial Catalog=Databasename;User ID=sa;Password=admin”

1 Like