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


Please Help Members By Posting Answers For Below Questions

What is Associate Repository in QTP 9.2 ?

603


what is ODC and GDC?

7353


if mandatory and Assitive propertys are shows same how will u write skript in QTP window

1628


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

2057


Is virtual object supported in low level recording mode?

623






Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)

1637


Can we write winrunner language i.e TSL in QTP tool?

1475


What are the differences between quicktest professional (qtp) and winrunner?

574


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

2350


Tell me about your project? please help me how to tell about insurance project

1535


What is data driver in qtp? Where we use it?

565


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.

1712


how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

1429


Mention the different actions types of qtp.

575


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?

1851