Quickly and accurately retrieve database connection strings using udl files

Quickly and accurately retrieve database connection strings using udl files

You can change the file suffix to. udl and connect to the database.
The procedure is as follows:
1. Create a new text file with the suffix udl, for example, A. udl;
2. Double-click a. udl to open and configure the database;
3. After the configuration is successful, open a. udl in notepad and find the following characters. The red part is the database connection string we need.
[Oledb]
; Everything after this line is an ole db initstring
Provider = sqloledb.1; Password = 13164464; persist Security info = true; user id = sa;
Initial catalog = zipcode-Taiwan; Data Source = LTI-jailu