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
- 4720 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
What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)
what is the difference between built-i function and In-built function?
How many types of run modes are there in qtp?
can any boby tell me what is method or steps to connect the remote desk top by using QTP 9.2 version?
Explain how you can delete excel file in qtp?
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
Why bpt?
which type of testing process are you following in ur company? how to recognize a qtp page?
what is stepin & stepout?
When you open QTP, how many sheets you can see?
What are the differences between qtp and winrunner?
I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
I have enrolled for a QTP course which is a four weekend course.Do you think its a good way to start off learning this tool?What all do i need with me in order to become a pro at using this tool?
