LoadRunner Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

ray500
Collector

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

5 REPLIES
Shlomi Nissim
HPE Expert

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

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

 

Highlighted
ray500
Collector

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

Thanks Shlomi!

SSHH
Acclaimed Contributor

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

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!

 

 

PerfGeek
Acclaimed Contributor

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

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

Lr_test
Occasional Contributor

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

Writing SQL statements in vugen is explained in a simple way

 

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

//Add this to "OnDomLoad" event