For this reason only I asked which database sql server you are using if you are using MySQL database u should download mysql odbc
sorry for misunderstanding. I have sql server database.
Go to start menu and type for odbc connection App based on your sever version select source I mean if it 32/64 bit select accordingly and follow the steps
ok @DivyaT. Needs admin rights to install? because m getting odbc data source(32/64 bit). whether I need to proceed with that only or there is anyother odbc connection?
This is based on the security implemented by the IT team in your company.
Please make sure you are able to connect to the DB of the server which you are trying to connect from UiPath. And then try the same by providing the connection string of that particular DB
that my concern how i can connect to db on another machine through uipath.
Usually, coming to the real scenario’s, we will have DB’s located in client place or in some servers which are located on another locations. We will have the IP or machine name of the server where the DB is located, respective port and the service name or SID. We need to use those to connect to the DB with the credentials.
So, to connect in Uipath, you need all these and the connection string format for the respective DB you are trying to connect
Ok @HareeshMR I’ll try to connect. Thank You 