Skip to main content

VB Script and ADO DB

VB Script can be used to establish db connection. This is very useful in QTP for writing db test cases. DB connection can be established for both SQL Server Authentication as well as Windows Authentication -

#########################################
Function Func_dbConnect

On Error Resume Next

'Creating the Connection Object
set cn = CreateObject("ADODB.Connection")

'Setting the Data Source
strCS = "Driver={SQL Server}; Server=1.1.1.1; Database=GSBREG_021010; UID=us; PWD=us;"

'Open Connection
cn.Open strCS

If (Err.Number<>0) Then
MsgBox("Login Failed")
End If

Set Func_dbConnect = cn

End Function


Sub ExecuteSQLQuery

Set cn = Func_dbConnect()

'Creating RecordSet Object
Set rs = CreateObject("ADODB.recordset")
rs.CursorType = 2

'SQL query
FetchAcademicLevels = "Select even_id from allocation_event"_
&" where allocation_name = 'myname'"

Set rs = cn.Execute(FetchAcademicLevels)

If(rs.EOF) Then
MsgBox "No Records"
Else

For Each x in rs.Fields
MsgBox x.name
MsgBox x.value
Next
rs.MoveNext

End If

rs.Close
cn.Close

End Sub


ExecuteSQLQuery()
#########################################

For Windows Authentication Connection String should be -

#########################################
strCS = "Driver={SQL Server}; Server=171.64.216.197; Database=copernicus_gsbreg_b2b_new; Trusted_Connection=Yes"
#########################################

Comments

Popular posts from this blog

Using chrome console to test xPath and css selectors

Note: If you are new to java and selenium then start with selenium java training videos .       Since the advent of selenium there have been many plugin to test xPath / css selectors but you don’t need any of them if you have chrome browser. Using Chrome console you can test both xPath and css selectors. Launch website to be tested in chrome browser and hit F-12 and you would see chrome console opened in lower pane of application - Hit escape key and console would open another pane to write element locators - And now you can start writing xPath or css selectors in chrome console and test them - The syntax for writing css id - $$(“ ”) And hit the enter key. If your expression is right then html snippet of the application element corresponding to the css selector would be displayed - If you mouse over the html snippet in chrome console then it would highlight the corresponding element in application - If you want to clean console of previously wri

Verify email confirmation using Selenium

Note: If you are new to java and selenium then start with selenium java training videos .     Email confirmation seems to be integral part of any registration process. I came across an application which lets you provide your email address. You can follow the sign up link in you mail and then complete the registration process. Lets consider we provide GMail address for it. Now if were to use only Selenium then we would have to follow following steps - Launch GMail using Selenium; Some how search for new mail in the list of available mails; Some how click on it; Parse the mail message; Get the registration link; Follow up with registration process What do you think of an approach in which you can

Distributed Load Testing with JMeter

Distributed Testing with JMeter When one JMeter client is not able to offer amount of threads required for load testing then distributed testing is used. In distributed testing - One instance of JMeter client can control number of JMeter instances and collect data from them Test plan does not need to be copied to each server, the client sends it to all servers note - JMeter will run all the threads on all the servers, hence 100 threads on 5 JMeter server would pump 500 threads in total. If many server instances are used, the client JMeter can become overloaded and so the client network connection. This has been improved in latest versions of JMeter by switching to Stripped modes, but you should always check that your client is not overloaded When Client (master) and Server (slave) nodes are on same network (no SSH required) Configure Client Node Herein client is referred as the machine controlling test execution on other JMeter nodes. This is also referred