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 |
I am using environment variable xml to give credenatials for login into unix. Is there any way we cam mask the password in the xml?
Give answer with example what is orthogonal array testing technique?
What are benefits of qtp?
hi everyone today is the first time i saw this website,and hi iam siraj,iam very impressed by seeing evryones response towards questions,iam a newcomer and i have got tryining in testing can anyone please send me some projects relaited to testing.i know it is very confidential but still if u send it will a great help. my mail id venku_krs@yahoo.co.in
What r the different filters in defect in quality center
How can the name of a checkpoint be changed in Qtp
What is Descriptive Programing? In which cases, we will go for descriptive programing?
Hi all, I am New to QTP . I am Now in critical situtaion. I want to know How to create our own object respository for our application. please say the answer with example.
How to test results for qtp ?
How can I use the value retrieved by OUTPUT VALUE check point as Input for other Actions?
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 ?
Explain what the difference between Shared Repository and Per_Action Repository