Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to read password from a file in the system to connect to the database.
Is it possible & how??
Thanking in advance
Keshav
Something like this:
Temp:
LOAD @1:n as MyPassword FROM ...passwordfilehere...;
LET vPassword = peek('MyPassword');
DROP TABLE Temp;
CONNECT TO [Provider=...driver_here...;Persist Security Info=False;User ID=...username_here...;Password=$(vPassword);Data Source=...db_name_here...];