I have connected to db with the following string;
OLEDB CONNECT TO [Provider=SQLOLEDB.1;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;
But when am trying to reload everytime its asking the password.How to avoid this.
Solved! Go to Solution.
Thanks Ashfaq.The settings has been done earlier But when am checking in the mentioned connection name no word with Password only i have userid.
So is it i have to better to connect again to the DB with the option you mentioned in the image right?
If you have access to the database it should work with "Use Windows NT Integrated security" und Data Link Properties / Connection /2. Enter Information to log on to the Server.
It is generally advisable to have SSO (from your own client or from the Server you work from) rather than storing passwords in strings.