This post will give u steps(script)to connect to database using MS Access.
Option Explicit
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("ADD").Click
rs.movenext
Loop
Database we are using here is MS Access.before running this script create a table in MS Acess.
In the above script i used table called "emp" and column names as "v1" and "v2".
"d:\testdata.mdb" is path of the table which we created.
Main use of this application is to use testdata of table(which is in database) in the application.
Qtp script for connecting to sql server and oracle
QTP Script for connecting to database
Subscribe to:
Post Comments (Atom)
7 comments:
Try this.... its working
Dim con,rs
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.oledb.4.0"
con.open"C:\Documents and Settings\C5107978\My Documents\db1.mdb"
rs.open"select*from table1",con
Do while not rs.eof
Reporter.ReportEvent micPass, "access opened"," emp"
Dim val1,val2
set val1= rs.fields("emp")
set val2= rs.fields("con")
Reporter.ReportEvent micPass,val1," emp"
Reporter.ReportEvent micPass,val2," emp"
rs.movenext
Loop
hi manasa,
thnx for ur comment but u need to change ur script to get correct output.
in line rs.open"select*from table1"
u have to specify name of table.
n other mistake is while setting values of val1 and val2 u need to specify column names as
set val1=rs.fields("column1name")
set val2=rs.fields("column2name")
if u correct this remaining code is perfect check ur own code n check this changes u vl know difference.
HI..
Can u also provide script for connecting to database that is sqlserver..
I am trying this since many days but not able to succeed.. i would be very thankful if u provide me the script for connecting sql server
Hi,
check this link for ur query
http://funandknowledge.blogspot.com/2008/03/qt.html
Hi guys,
For the above script, i am getting error in path. Anybody can tell me, other then mdb, we can use any other extension.
The above script i tried but i am getting an error for the path. Anybody can tell me other then mdb, we can us any other extension.
Hey i am getting following error, can anybody help:
"Data source name not found and no default driver specified"
Post a Comment