Steps to obtain connection string from sqlserver and MySQL

Time:2021-10-19

Steps:

1、 Create a new text document xxx.txt and modify the file type to. UDL

2、 Open the file and find the corresponding service in provide data.

3、 Select the required database in the connection and fill in relevant information.

4、 Test the connection. If it succeeds, skip to the next step. If it fails, the user information is incorrect. Modify it again.

5、 Change the suffix of xxx.udl to txt and open it to find the connection string.

Note: there is a provider in the connection string found here, which may not be supported. If not, please change it to server