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
- 4317 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How 2check the color of the text in the textfield . say suppose the text entered in the textfield object is appearing in red. so i want to check whether the text is in red color or not. It could be great help for me if any one solve's my issue. plz...help
What is the Automation Process followed in your company?
Hi Samrat, Thank u very much, what u said it is right.
How many types of Parameters are available in QTP? and Pls Explain with example.
WHat is Object Identification and Object Spy?
Explain the check points in quicktest professional?
Explain getroproperty and gettoproperty & settoproperty?
What is action required by QTP if a popup message is coming in exsisting script and now it is not coming. The script is having code to deal with popup message now when we run the script now the popup i snot coming according to new build, instead of changing the code what we can do?
what is virtual object?
How to handle the errors without using recovery scenery?
Hi Friends,will any body tell to Me for which Auomation Tool their is great Requirement inht eMarket Eithr the QTP or WINRUNNER and for what reason and how long it is going to remain and wat the Scope for the automation Testing In the Future Please tll to Me In Details Ok .
What is the difference between Accessibility Checkpoint and Bitmap Checkpoint in QTP? Note: I have read it in QTP help but i dont want answer from that.......
WinRunner 
