Database Connection issue


#1

Hi Guys

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

“Dsn=ttrd.world;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 “Dsn=ttrd.world;uid=” skipping the remaining portion wbsrt";pwd= com56".

Can you please guide us on this

Error Message : {
“message”: “Dsn=tts.world;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”
}

Thanks
Kamesh


#2

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”