SQL database connection string (Persist Security Info)

When connecting to a database with a. UDL, select Allow Persist Security info=true when saving passwords, otherwise false

The Persist Security Info property is meant to indicate whether or not to save secure information, in fact, it can be simply understood as "whether ADO saves password information after a successful database connection",

True means save, false means no save

The default for ADO is False, not tested, according to the reference

This can be verified by the ConnectString property of the Connect object of ADO, as shown below

----------------------------------------------------------------------------------------------------------

Before database connection

Connectstring= "Provider=MSDAORA.1; Password=mypassword; User Id=yzs;data source=ydgl22; Persist Security info=false"

After the database connection is successful

Connectstring= "Provider=MSDAORA.1; User id=yzs;data source=ydgl22 "

----------------------------------------------------------------------------------------------------------

Before database connection

Connectstring= "Provider=MSDAORA.1; Password=mypassword; User Id=yzs;data source=ydgl22; Persist Security info=true"

After the database connection is successful

Connectstring= "Provider=MSDAORA.1; Password=mypassword; User id=dlyx;data source=ydgl22 "

SQL database connection string (Persist Security Info)