Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

Answer / kishore

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 ?    1 Yes 5 No

Post New Answer

More QTP Interview Questions

what is stlc and its contents?

1 Answers  


What is keyword driven framework, what is "key" in It.

2 Answers   IBM,


We developed 100 descriptive programms and put in running, in the midle if any descriptive program is stucked with some error? what will happend weather it will execute the remaining prg's or it will terriminate ?

6 Answers   Kanbay,


what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

0 Answers   Intel, Satyam,


HOW TO AUTOMATE CAPCHA IMAGES while creating Gmail account

2 Answers   TCS,


Hi any body pls help me for QTP 11.0 software free demo version. i have to practice. Kindly send the link.or where i have to download.

0 Answers  


Hello Friends, I am working with QTP 9.2 descriptive programming. Can you please let me know how to work with below. Browser is IE, for my site, it opens another page with different browser name, For example Parent Page is google.com and child page is inteview questions. How to work with this second page.

3 Answers  


Hoe we can export TEST RESUALT IN to XL-sheet?

1 Answers   IBM,


write vbscript in qtp tool for senario, in the given sheet add each number in each row and each colunm and show result

3 Answers   Mind Q Systems,


We have an application which generates links( more than thousand) based on the time stamp dynmically.Each link will download an xls file. we are supposed to click a particular link (which link to click will be obtained thru some buisiness logic).Now the issue is QTP is not recogniging the link(say Var1) though its properties showed mandatory fields text=xyz and html tag=A.I used following code to do this. Browser("ABC").Page("123").Link("text:=" &Var1,"html tag:=A").click, can any one suggest why this is not recognised by QTP though syntax is correct?(Is there any sync issue to be considered?Because on clicking the link it will take 5 mins to open that file)

3 Answers  


How does QTP identifies the object in the application Mainly objectives are three type's OF PROPERTIES namely

3 Answers  


Give a comment on Regular Expressions using QTP?

4 Answers  


Categories