how i will connect oracle or microsoft acess database
through manually written Script
Answer Posted / baba fakruddin
'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 |
Post New Answer View All Answers
What is Associate Repository in QTP 9.2 ?
what is ODC and GDC?
if mandatory and Assitive propertys are shows same how will u write skript in QTP window
Qtp has been installed on my pc but recently ON opening it is giving this error PLEASE REPLY IT IS URGENT IT WAS WORKKING FINE QTPRO.EX THE instruction at "0x7.. ...". referenced memory at "0000....The memory could not be read... Awaiting QTP XPERTS REPly URGENT
Is virtual object supported in low level recording mode?
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
Can we write winrunner language i.e TSL in QTP tool?
What are the differences between quicktest professional (qtp) and winrunner?
I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error
Tell me about your project? please help me how to tell about insurance project
What is data driver in qtp? Where we use it?
Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.
how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance
Mention the different actions types of qtp.
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?