How to handle exception when data table is not available in local host sy

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

How to handle exception when data table is not available in 
local host system or path is not correct(explain statement 
with example)

Question Submitted By :: Padmasekharpediredla

I also faced this Question!!

Rank

Answer Posted By

Re: How to handle exception when data table is not available in local host system or path is not correct(explain statement with example)

Answer
# 1

Dim Dsn_conn,rs

Set objConnection=Createobject("ADODB.Connection")
Dsn_conn= "DSN=QT_Flight32;DBQ=C:\Program Files\Mercury 
Interactive\QuickTest 
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINNT
\system32\odbcjt32.dll;DriverId=281;FIL=MS 
Access;MaxBufferSize=2048;PageTimeout=5;"
objConnection.Open(Dsn_conn)
Set rs=CreateObject("ADODB.RecordSet")


Set rs=objconnection.execute(" select  flight_Number from 
Flights where flight_Number>20330") (Instead of this 
statement search the table u will get it
)


rs.MoveFirst

While Not rs.EOF
	Msgbox rs.fields.item("flight_Number")
	rs.movenext
Wend

Is This Answer Correct ?

0 Yes

1 No

Shyam Prasad

Question	Asked @	Answers
Other QTP Interview Questions


There is a name "AJAY" how do u count no.of. "A" in that name ?		2
How Qtp will identifies object during run time	Yahoo	4
what is framework? which frame work u follow for writting script?	IBM	5
how can you describe the basic flow of automation with conditional and programmatic logic?	Ordain-Solutions	1
What is the Risk Analysis? Waht types of risk analysis are there?		1
How to export QTP results to an ".xls" file?		3
How do u retrieve data from a text file into different variables. i.e. in a text file named "source" , the data is like : india,1000,japan,200,china,50,singapore,45050 this is given in the first line of the text file. in the second line of the text file the dta is: sun,moon,planet,river,earth,water if u use "readline" method by using FSO concept u can retrieve the entire line in to a variable. but i want to import each field (ex: "india" in one variable, "1000" in another variable etc..). Apprecitae proper replies.	Semantic-Space	4
hi. I Am working in Small IT company as Test Engineer. But am looking for change. I have 2+yrs experience, but my problem is MCA 72%, remaining all are Second Division. plz give solution for my problem.am elgible for MNC's or not. if not plz give suggestion............ already i forwarded my resume to lot of MNC's but. I didn,t get CAL............ plz give any suggestion.		3
what are the 5 types of objects in qtp	Wipro	4
hi all, I have installed QTP successfully on windows vista. I am able to record and run on windows applications, but facing problem with web applications. While recording, I am able to open the web application, but when I click on any object or give login name and password, the events are not getting recorded in QTP. Could anyone solve the problem. Any settings to be done for web applications other than selecting web-addin? Waiting for replies. Thanks in advance.		2
w is active screen	Wipro	2
what is purpose of automation?		2
hi i have one issue while coding the dates . i want to add the date curret to 4 days . can any one helme plz about this regards balaji		2
how u conduct GUI testing and PERFORMANCE testing on MS- WORD? and What r the GUI Test Cases and performance Test Cases?	Syntel	3
the presentation layer of my application is built using VB 6.0 and a series of C++ dlls and components. We do not use Java, VB.Net, C## or any other component that can be decompiled. We are automating the application using HP Quick Test Professional. It is not reconginizing the combo boxes, tabs etc.... Could you please suggest, whether QTP supports C++ dlls and components or not...if yes, could you please guide me, how to overcome this situation. Can we install any special add-ins for this C++? .When we are performing the recording/execution, the application becomes very slow. Your quick response will be highly solicited in this regard.	Wipro	1
Hi any body can tell me the in detaled information about Description.Create() thanks in advance		2
LINUX environment supports QTP or not? LINUX environment supports QC or not?		2
how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?		2
What is the concept of firewalls?	CTS	2
what are recovery management techiniques?	BirlaSoft	2

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com