Hi all,
How to connect database, by storing the values in config file like username, password, server name, database, table name.
How to do this, guide me on this.
Once you create a connection and save you should be able to see the connection string from the properties…you can add variables in it and replace with values from config
cheers
@Anil_G , how to create the connect connection with the help of config file…?
Configure using hardcoded values and once saved take the connection string from properties and then replace with config values
After configuring you will get string here
cheers
you can create connection string in config file and call in connect activity
for create connection string follow this video
Hi @lakshmi.mp,
Use the database connection activity and put manually your credentials there, you will get a connection string which you can edit by variable created from your config file or queue or any other storing files you have stored your credentials in.
@Anil_G , can you share me any example on this
Click on connection wizard and fill details of any dummy or manual values…
after saving open properties panel and modify the connection string
cheers
@Anil_G , how to open properties and modify connection string…
Now if you need server name from config…
then use asssign with server_name of left and config value on right config("Servername").ToString
similarly for others
cheers
this error i am getting now… What to do.
As per error instance name or the server name procided is wrong…please check and giv wpropely…first give hard oded values and once works replace with original values
Cheers
mkankatala
ashokkarale
Yoichi
sven.wullum1
chandreshsinh.jadeja
sharazkm32
sonaliaggarwal47
Ankit_Kumar2
SorenB
fanmixco