What the genaric function to connect Sql Server using Sql
Server Authentication and Windows Authentication
Answer Posted / 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 View All Answers
How to save your test using quicktest professional (qtp)?
What is recovery scenario manager? When you go for recovery scenario manager?
Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B
Explain the difference between check point and output value?
With what extension you can save the list of tests in a file to run in test batch runner?
How many ways is to parameterize the value?
i'm using the qtp to test to vb appliction,i wanted to get the new application's title.i didn't want to use the winAPI to get it ,i 'd like to know whether a QTP function can do it. Eg: SystemUtil.Run "C:\Program Files\.....","","","" 'run an application, and misure the application is activating,then how to get the hwn wihtout using windowns api
To retrive the test data which tool vl use and whats basis u vl write test data? its urgent
How to use reporter.report event in qtp ?
What are the types of object repository?
How qtp recognizes the object?
How to test login module with different username and password by using data driven testing in QTP?
What are the differences between quicktest professional and winrunner?
Whats the realtime QTP testing process
How to sendKeys in QTP? Diff b/w sendkeys and device replay? Diff b/w function and Sub? Diff b/w Array and List Different Types of running Keys other than Fast, slow,Normal mode Regular expression for http://newtours.demoaut.com Difference between \w and \W How to generate script button Recording Types Different Types of Actions? Using DP performance degrades, If Yes why? How to close all the opened browsers? Diff b/w SystemUtil.Run and invoke application? If qtp not recognized the combo box How to select values from drop down?