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
- 4817 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
How you can delete excel file in qtp?
why should we give deliver good quality software?
Differentiate the type of test cases which can be automated and which cannot be automated?
How to use the object spy in quicktest professional 8.0 version?
Explain the types of object repository?
What are the major/ important methods, functions in QTP we use realtime testing
In the website, the protocol has been changed http: to https what you will do? Tell me your approach?
desribe a situation where u faced a stressful situation and how did u cope with it
How many types of status are there?
What are the views available in quicktest professional?
what is the hierarchy to use properties in descriptive programming
How does qtp identify the object in the application?
How to test fly out menu in qtp?
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
What is throw object?
