ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question 
Hi I have created a table in the MS access database. I want 
to access the table in this database through QTP. The code 
is given below. The code is not working.The following error 
is displayed "Data source name not found and no default 
driver specified". Any one can correct the code. Thanks in 
advance.
Dim dbconnection, rs
Dim ca, sname
Set dbconnection = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")
dbconnection.open "DSN = MS Access Database","", ""
rs.open "select  *  from  Research", dbconnection
rs.movefirst
If rs.EOF <> True AND rs.BOF<> True  then

ca = rs("order_number")
sname = rs("customer_number")
rs.movenext
msgbox ca
msgbox sname
End If
 Question Submitted By :: Venu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Hi I have created a table in the MS access database. I want to access the table in this database through QTP. The code is given below. The code is not working.The following error is displayed "Data source name not found and no default driver specified". Any one can correct the code. Thanks in advance. Dim dbconnection, rs Dim ca, sname Set dbconnection = createobject("ADODB.Connection") Set rs = createobject("ADODB.Recordset") dbconnection.open "DSN = MS Access Database","", "" rs.open "select * from Research", dbconnection rs.movefirst If rs.EOF <> True AND rs.BOF<> True then ca = rs("order_number") sname = rs("customer_number") rs.movenext msgbox ca msgbox sname End If
Answer
# 1		 
Hi,


you should to give proper DSN(datasouce name) and its path 
of the MS-Access i.e like for Eg:'D:\mydatabase\list.mdb"

I think you understood my point
 
Is This Answer Correct ?    0 Yes 1 No
Lakshmi
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
Which object repository we use in real time and can we merge 2 object repostiory and how? HCL6
hi i have one issue while automating the script using QTP i want scrool down .i cannot do even using scrool down methqad is not working .the object will take WebElement plz is there any code help me  2
Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???  1
What is the use of virtual objects?  1
Can we call a parameter from an action to other action?  4
in how many ways we can write the user defined functions one way i know that i.e storing it in .vbs another way i does not know my friend said that .qtf or something but start with q letter can any buddy knows about this DigiTech3
Plz explain about Virtual object? What is the situation u r using , explain with example?  1
what questions i have to pripare for project manager round interview ? plz give Ans.(Chandana) TCS3
I am struggling to understand QTP more from descriptive programming point of view. Is it easy to learn good QTP in South india by good faculty than north india? I found a great lack of institution in here. can you suggest me better instituion. I am holding two years of experience in same company, is there possibility in south india for me?  1
DIFFERENCE BETWEEN WR 8.2 & QTP 8.2? HOW TO INTEGRATE WITH SOME OTHER TOOLS? CTS1
What is descriptive programming? Wipro14
What is a Run Time Data table?  1
Give a comment on Regular Expressions using QTP?  4
What is data driven testing in QTP? Agile-Software6
When Object Repository is available what is the necessity of having Descriptive programming which needs more scripting efforts.  2
What does it mean when a check point is in red color? what do u do?  1
How can we redirect QTP results in to a excel sheet after the execution Virtusa2
How does QTP identifies the object in the application Convergys5
Hi everybody, Can anybody tell me that how the QTP frameworks are implemented . I wanted to know with examples . Thanks in advance  1
What is the use of Accessibility check point?  2
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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