how i will connect oracle or microsoft acess database
through manually written Script
- 2 Answers
- 6163 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 |
Whether qtp 9.0 supports Test director8.0
There is an excel file of 1 to 100 sheets how you will iterate through it?
Diff between WEB APPLICATION AND CLIENT-SERVER APPLICATION?
What is the syntax to call one action in another?
Can u Reduce the size of Object repository? What are the problems u have faced in Qtp tool?
You have an application version 1 with 5 combo boxes, Developers develop version 2. Here they replaced bottom 3 combo boxes with each other. While executing the Test script for version1 no errors. When we execute the Test script for version2 that QTP showing the error message "Object not identified" remember no property changed in version 2, ordinal identifier also disabled. Find what properties might change here in this scenario
what is the code in QTP to take screen shot?
How do you create regression test packs?
What are the differences between quicktest professional (qtp) and winrunner?
What is the method for maximize the application while we using Decriptive programming in QTP?
what is the criteria for choosing test cases for automation? Ex: if you have some 300 test cases, then how many you choose for automation. what is criteria of selecting?
3 Answers Aricent, Delhi University, TCS,
in how many ways you perform batchtesting?
WinRunner 
