LR parameterized connection to SQL Server database

1. After the script is recorded, select the value to be parameterized and right-clickReplace...

 

2. SelectProperties ...,After entering the page, selectData wizard...

 

3.Specify SQL statement manually, Next step

 

4. PointCreateAnd then click "new". The page for creating a new data source appears.

 

5. SelectSQL Server, Next, click "Browse" to create a file and select the storage path. Next, click Finish.

 

6. The "create SQL Server" data source appears. The description can be left blank. The server writes the IP address of the machine to be connected. (The drop-down box automatically scans all IP addresses in the LAN)

Next, select "verify the login ID and password entered by the Trial user". Write the login name and password below. SQL server uses Sa by default.

 

7. Change the default database (the database to be connected) and click Next.

 

8. Test the data source. Success ~ Hey

 

9. ReturnData wizardSelect the created DSN File. After the database is connected successfullySQL statementlWrite the query statement, and the query structure is automatically written.