What the genaric function to connect Sql Server using Sql
Server Authentication and Windows Authentication
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 |
How to add synchronisation points in qtp?
How did u write macros?What is the main importance of VB macros in testing environment?
What is the default add-ins in qtp?
How function returns a value?
how to acess a test in RSA?
Hai anyone please "Explain about Framework in QTP?"
how can I read text in browser and export the same into text file?
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.
Hi All, I want to know how can we schedule QTP scripts. Am using 9.5 version and in our office they want to schedule individual scripts of QTP so that it can run unattended during night time, Please help me how to do that. 2. what is the use of silent test run in qtp can I schedule the scripts in Silent runner, Please explain. 3.I retrieved data from the database using output value -> Database output value. the result of the query for eg is 5 rows, iam able to output the first row by selecting the cols and adding it to output, but am not able to do it for the rest of the rows. please tell me how to do it. Sorry for posting so many qns, am not able to find answ to any of the above in any websites, hoping that someone would really help me with these here, please help me. awaiting for ur immediate revert. Priya
4. How u will open the build automatically in QTP except using Systemutil.run command
Hi,will U Please Provide me details certification for QTP &QC and also please provide me the Material also. Send to mail:jjaanu2mail@gmail.com
How to import excel sheet to QC?