how i will connect oracle or microsoft acess database
through manually written Script
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 |
What VBScript operators, functions, and statements do you use in QuickTest Professional?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
how can we do the frame work in qtp
I have a drop down box to show selected number of records in result page.It contains 4 items like 10, 25,50 and 100. when i was recordes script for seelcting each item and checking selecting number of records in the result page( it is in the same page in the table format)it is generating a new page with same controls( objects) in the OR. how to avaid these in OR? is it possible to write DP for only these lines?, remaining(remaingin lines of code) objects i want use from OR only. One more problemis if change ( add /remove properties of an OBJECT in OR , my ( recorded )application is not running.
Why use Regular Expressions?
How u perform exception handling in QTp,what is other name for ths
Java add-in is need to work on java oriented project ?
What are the problems / difficulties faced when you used Smart Identification ?
What is the D/B Test managemet tool and bug trcking tool? Ans send to pbr.qtp@gmail.com
In a WebTable 2nd row,3rd column contains one link and that link name is changing dynamically. How you will click the link?
does test plan is in test strategy or test strategy is in test plan
What are the different types of action?