UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
Absent Member.. Absent Member..
Absent Member..
7047 views

Are there any ODBC Vuser sample scripts for connecting to SQL Server 2008?

Hi,

 

I am trying to run insert/updates/queries using odbc attempting to connect to SQL Server 2008 from Loadrunner Vuser.   Does anybody have sample scripts that demonstrate the odbc parameters used to connect and to execute sql statements specifically in SQL Server?   The only samples I find in the LR documentation and in forums are mostly for Oracle.

 

Thanks,
Raymond

Tags (1)
0 Likes
5 Replies
Fleet Admiral
Fleet Admiral

I have attached a sample script. It checks how well the database server can deal with concurrent connections.

 

0 Likes
Absent Member.. Absent Member..
Absent Member..

Thanks Shlomi!

0 Likes
Absent Member.
Absent Member.

Hello there, I am trying to record a script using ODBC protocol. The client server app is Plexis claims Manager. It is a simple script that searches claims with claim ID and process it. I am having an issue whether to follow the same pattern of parameterization/correlation as web(http/html) or different. let me know if anyone has an experince using it.

 

Much appreciated!

 

 

0 Likes
Absent Member.
Absent Member.

Hello Schlomi, Everyone on this community:

 

Can you tell me how we can make your script work for Teradata? I have tried to use the existing ODBC connection, but it returns with error from the database. 

 

If you have a special script sample for Teradata SQL, let me know. 

 

Thanks in advance,

j

0 Likes
Absent Member.. Absent Member..
Absent Member..

Writing SQL statements in vugen is explained in a simple way

 

http://loadrunner95.blogspot.com/2016/10/oracle-database-load-testing.html

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.