LoadRunner parameterization using MySQL data source

1. install the MySQL driver. http://dev.mysql.com/downloads/connector/odbc/,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/D9/wKioL1WreVThInkKAAFqZeGLTUg371.jpg "title=" 1.png " alt= "Wkiol1wrevthinkkaafqzegltug371.jpg"/>

According to the operating system download the appropriate driver, click Download, pop up the following interface:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/DC/wKiom1Wrd6ixCSo6AAFBcVTeYRQ582.jpg "title=" 1.png " alt= "Wkiom1wrd6ixcso6aafbcvteyrq582.jpg"/>

Directly click "No Thanks, just start my download. "can be downloaded.

2, install the driver, double-click the driver installation package, select the default installation can

3. After successful installation, select Control Panel-Administrative Tools-Data Source (ODBC), open the ODBC Data source management interface,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6F/D9/wKioL1WredLRiz6YAAFgel73hxo994.jpg "title=" 1.png " alt= "Wkiol1wredlriz6yaafgel73hxo994.jpg"/>

Check "drivers" to see the drivers you just installed,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6F/DC/wKiom1WreECx9sEWAAJf9hlEH9c529.jpg "title=" 1.png " alt= "Wkiom1wreecx9sewaajf9hleh9c529.jpg"/>

Select "User DSN", click Add, add the driver you just installed,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/DC/wKiom1WreJ6TQKj6AAH2Ym6JlQk587.jpg "title=" 1.png " alt= "Wkiom1wrej6tqkj6aah2ym6jlqk587.jpg"/>

Select the driver and click "Finish" to bring up the following interface:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6F/DC/wKiom1WrePWT9XPxAAF26g4AeVU020.jpg "title=" 1.png "alt=" wkiom1wrepwt9xpxaaf26g4aevu020.jpg "/>

in Data Source Name and description, feel free to fill in. The server fills in the IP of the servers, I use the native database , so fill in as 127.0.0.1

The User name and password are needless to say. Database is to select the databases to use, point to test . Well, the connection was successful.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6F/DC/wKiom1WreWqBgRq7AAH2ktkzasA432.jpg "title=" 1.png " alt= "Wkiom1wrewqbgrq7aah2ktkzasa432.jpg"/>

Click OK.

4. Open Virtual User Generator, select the vuser-parameter list,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/DC/wKiom1WrearhbcT6AAFI3Q4dHqY663.jpg "title=" 1.png "alt=" Wkiom1wrearhbct6aafi3q4dhqy663.jpg "/>650) this.width=650; src=" http://s3.51cto.com/wyfs02/M01/6F/DC/ Wkiom1wreeks_ldpaafhtnpeit0342.jpg "title=" 1.png "alt=" wkiom1wreeks_ldpaafhtnpeit0342.jpg "/>

Click the Data Wizard,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6F/DC/wKiom1WrehrQd8EUAAEloNe2BlY997.jpg "title=" 1.png "alt=" wkiom1wrehrqd8euaaelone2bly997.jpg "/>

Select "Specify SQL statements manually" and click Next,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6F/D9/wKioL1WrfDfAVJWhAADYD6_ofUo910.jpg "title=" 1.png "alt=" wkiol1wrfdfavjwhaadyd6_ofuo910.jpg "/>

Note: This time the operating system is window 7 64bit, just start to install 64 of the driver, after selecting the data source, displayed as blank, later found that their MySQL is 32-bit, and then installed a 32-bit driver, select the data source, you can display.

Click "Create" to select the data source you just created in the machine data source,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6F/DC/wKiom1Wrep7yF91HAAFRZBBgsxw697.jpg "title=" 1.png "alt=" wkiom1wrep7yf91haafrzbbgsxw697.jpg "/>

Click OK, connect character display driver name, enter query statement under SQL statement,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/D9/wKioL1WrfL2zWEhjAAEMiQ28gJA284.jpg "title=" 1.png "alt=" wkiol1wrfl2zwehjaaemiq28gja284.jpg "/>

Click Finish, data import successful

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/D9/wKioL1WrfPGRsaKMAAEwRVp_sgE943.jpg "title=" 1. PNG "alt=" wkiol1wrfpgrsakmaaewrvp_sge943.jpg "/>

This article is from the "onlyweeds" blog, make sure to keep this source http://5870122.blog.51cto.com/5860122/1676121

LoadRunner parameterization using MySQL data source