LoadRunner Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

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

Regular Advisor

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

4 REPLIES
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
Regular Advisor

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

Thanks Shlomi!

Senior Member

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!

 

 

Occasional Advisor

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