How to Test ODBC Data Sources Using Loadrunner

It can be convenient to test databases using Loadrunner to take advantage of its parameterization and other functionality.  One easy way to get started with this is to to use ODBC vuser type and record the transaction through some ODBC client.  This post describes one way to do this.

Install WinSQL Lite, which can be used for free. http://synametrics.com/SynametricsWebApp/WinSQL.jsp

Start WinSQL and configure an ODBC data source to your database.

Test the connection.
Create a new vugen script of type ODBC and choose the WinSQL as the application to launch:

Vugen will then launch the WinSQL app and connect to the database, bringing up a query window.
Enter your query in the query window and execute it:

Disconnect within WinSQL.
Stop recording within vugen.

You now have your script which can be modified, rearranged and parameterized as needed.