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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use setroproperty?

1081


What are the views available in quicktest professional?

1073


What are the advantages of qtp?

1049


What is test object model in quicktest professional (qtp)?

1054


What VBScript operators, functions, and statements do you use in QuickTest Professional?

2720


i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click

2062


How to capture a window in QTP?

2031


What is environment variable in qtp and why to use it?

1071


What will be happen if i load object repository at run time, but it has already associated.

1846


How to get the format of a webedit class in qtp. How can i know that particular webedit accept what type of format like "mm/dd/yyyy" or "$" or Alphanumeric

2123


How many types of trigger events are there in qtp?

1079


How to test login module with different username and password by using data driven testing in QTP?

1209


How do you open adobe acrobat file in QTP and do some testing on that file ?

1115


What is text check point and text area check point?

1146


What is the difference in testing a client-server application and a web application?

1167