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...


What the genaric function to connect Sql Server using Sql
Server Authentication and Windows Authentication



What the genaric function to connect Sql Server using Sql Server Authentication and Windows Authen..

Answer / kotike

Function DBConnect(Constr)
set oCon=CreateObject("ADODB.Connection")
oCon.open Constr
if oCon.State=0 then
msgbox "connection not opened"
end if
set DBConnect=oCon
End Function

where ever required just call this function and define the
connection string.

ex: set con=DBConnect("Driver=;Server=;database=;user
id=;passwoerd=")

Regards,
mahi.kotike@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

Can you write a script to check if the folder exists or not?

0 Answers  


Iam trying to write script for Rediffmail Page,in doing so the script line for go button is not accepting. Is their any other way other than . Browser("micClass:=browser").Page("micClass:=Page").Link ("micClasss:=Link","name=go")

2 Answers  


In automation testing, while doing descriptive programing; how will u get the properties of the objects in what format, what type of a document, and by whom? Pls explain in detail. Thanks a lot

2 Answers   Quest,


Explain how you can find the absolute value of the number in qtp?

0 Answers  


Give the syntax to import/export xls into qtp.

0 Answers  


what is keyword driven testing

2 Answers  


Can we use same virtual objects in many number of tests?

1 Answers   TCS,


Explain hybrid framework with advantages and disadvantages?

0 Answers  


I have two actions in my QTP test and two iterations in my DataSheet. I want to execute the Action 1 for the two iterations only after which i want to exceute the next Action2. How is this possible?

4 Answers  


Is it possible to change the values of analog recording?

0 Answers  


I am new to automation testing.I am learning QTP 9.2.my question is how to install the defferent addins(other than Default Addins) is there any defference in QTP after installing the Addins.where we can get the addins?

0 Answers  


what is the extension for the test version of the script?

5 Answers   TCS,


Categories