Interested to Buy Any Domain ? << Click Here >> for more details...
how i will connect oracle or microsoft acess database
through manually written Script
- 2 Answers
- 7312 Views
- Aurigo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sashikanth
DIM ADDCON
DIM RECSET
SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION")
ADDCON.OPEN "DSN= ;UID= ;PWD= ;"
SET RECSET = ADDCON.EXECUTE("SELECT.....)
WHILE RECSET.EOF
.........
.........
WEND
SET ADDCON = NOTHING
SET RECSET = NOTHING
| Is This Answer Correct ? | 0 Yes | 1 No |
'This is for Microsoft Access
dim con,rs
set con=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.oledb.4.0"
con.open "d:\testdata.mdb"
rs.open "select * from emp",con
do while not rs.eof
vbwindow("form1").vbedit("val1").set rs.fields("v1")
vbwindow("form1").vbedit("val2").set rs.fields("v2")
vbwindow("form1").vbbutton("validate").click
rs.movenext
Loop
' Oracle Connection
con.open
"provider=oraoledb.1;server=localhost;uid=scott;pwd=tiger;datbase=testdata"
| Is This Answer Correct ? | 0 Yes | 2 No |
I Scheduled a QTP Script on remote desktop. Script is going to failure,when remote desktop connection fails.I have to open my remote desktop untile the scripts exection completes. If I disconnect my remote desktop connection, script is going to fail.?
what is batch testing?
what is defination of intergration testing?
To which environments does a QTP support?
Write code for ,We have a web table with rows and columns like EmpID EName Action 1 ABC Edit Delete 2 XYZ Edit Delete 3 PQR Edit Delete In the above Table the last column has two links we have to click first link based up on EmpID =2
What are the general steps involved in the data driven framework?
how can i use text check point in descriptive programming. or else is there any way to compare the text in the application and the text in data table.
Explain the views in the QTP GUI?
How do u connect database through QTP tell me both Ms Access and SQL
What is the difference between Dim And Redim
4 Answers Hotel Jobs, IBM, Microsoft,
For Usability testing, which is preferable Automation or Manual?
distinguish between old version and new version QTP features.
WinRunner 
