Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have created a table in the MS access database. I want
to access the table in this database through QTP. The code
is given below. The code is not working.The following error
is displayed "Data source name not found and no default
driver specified". Any one can correct the code. Thanks in
advance.
Dim dbconnection, rs
Dim ca, sname
Set dbconnection = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")
dbconnection.open "DSN = MS Access Database","", ""
rs.open "select * from Research", dbconnection
rs.movefirst
If rs.EOF <> True AND rs.BOF<> True then
ca = rs("order_number")
sname = rs("customer_number")
rs.movenext
msgbox ca
msgbox sname
End If
- 1 Answers
- 4633 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Hi,
you should to give proper DSN(datasouce name) and its path
of the MS-Access i.e like for Eg:'D:\mydatabase\list.mdb"
I think you understood my point
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Who uses qtp tool?
What is text check point and text area check point?
How many ways we can parameterize data in quicktest professional (qtp)?
Hi, how can we check or avoid the memory leakage in QTP9.2?
Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.
Explain different checkpoints in qtp.
How many types of recording modes in qtp?
Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji
How to customize qtp?
what is the difference between built-i function and In-built function?
give me an example where u used good judgement and logic in solving a problem
How to modify the text checkpoint?
How software tester can use constants and variables in scripts?
How to remove the associated function library?
what the difference between shared repository and per action repository?
