Are there any ODBC Vuser sample scripts for connecting to SQL Server 2008? (2356 Views)
Reply
Highlighted
Regular Advisor
Posts: 142
Registered: ‎10-27-2011
Message 1 of 5 (2,356 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

HP Expert
Posts: 189
Registered: ‎08-15-2009
Message 2 of 5 (2,324 Views)

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.

 

Visit LoadRunner Linked-In Group: http://www.linkedin.com/groups?about=&gid=1879289

Visit TruClient Linked-In Group: http://www.linkedin.com/groups/HP-TruClient-Software-group-4539324/about
Regular Advisor
Posts: 142
Registered: ‎10-27-2011
Message 3 of 5 (2,314 Views)

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

Thanks Shlomi!

Senior Member
Posts: 3
Registered: ‎01-06-2015
Message 4 of 5 (628 Views)

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!

 

 

Member
Posts: 4
Registered: ‎08-16-2011
Message 5 of 5 (47 Views)

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.