how to make connection to a remote mysql database in qtp any one can pleas

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

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 make connection to a remote mysql database in qtp
any one can please provid eme deatail steps.

Question Submitted By :: Vineela

I also faced this Question!!

Rank

Answer Posted By

Re: how to make connection to a remote mysql database in qtp any one can please provid eme deatail steps.

Answer
# 1

Set con = createobject("ADODB.connection")
   Set rs = createobject"ADODB.Recordset")
   Set com = createobject("ADODB.command")
   con.open( "Driver=SQL SERVER;Server=server name (Where 
DB is located);Database=DB name;Uid=uname;Pwd=pwd;" )
 vf_com.Activeconnection = vf_con

Is This Answer Correct ?

0 Yes

1 No

Kishore

Question	Asked @	Answers
Other QTP Interview Questions


I have the following Doubts Please clarify me with examples? 1.Could QTP cover entire application? or part of the application? 2.Shall we rewrite(modify) the Manual testcase to automate? 3.How can I execute my scripts through client mechine which is not having QTP installation 4.Few objects are not being identified by QTP afeter one month. what could be the reason for this (I am using trail version of 15 days)	Livetek	2
What is object repository?		2
I want to test advanced Java applications what kind of add- ins I have to install?		1
What is Version control?		2
what are the settings to be done to make the recovery scenario created for one test to be used bye all the other tests. please tell me recovery scenario process in detail.		1
What is meant by Repository?	Four-soft	5
Which scripting language QTP is using?		6
Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searching a field in the datatable	HP	2
how to tell about testing a website in interview using qtp?? what r the points to be covered mainly?		2
How we test the logo or images in the web page using QTP? For example take google page, they change their logo for new year,christmas etc..How we test that? Plz answer this question... Thanks in advance..		2
Why we have to split actions in a test?		4
in order to start automation testing what we should require (entry level to automation testing)		2
how to make connection to a remote mysql database in qtp any one can please provid eme deatail steps.		1
suppose our project is developed using java technologies.after complition of the coding developer relesed a build to the testing team.so, what is the process means how we open that documents?what are that documents?plz give reply its urgent		2
Hi. plz expalin abouit SetToProperty, SetRoProperty, GetToProperty, GetRoProperty,GetToPrperties. with examples.		3
Can you expect major bugs in Net banking Application?		1
how can u put synchronization point in qtp,wat is exactly synchroniztion why we use it wat is benifit in qtp		7
In real time whenever we found bug , after that where you send to that bug. send to T.Lead or Directly Developer. Plz explain me?		2
What is diff betwee datatable.importsheet "path" and datatable.import		2
What is the latest version in QTP?	Polaris	26

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