Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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

Question Posted / venu


Hi I have created a table in the MS access database. I want to access the table in this database t..

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

Post New Answer

More QTP Interview Questions

what is the difference between QTP 8.0 & 9.0?

4 Answers  

what is debugging testing?

5 Answers  

what is the main use of reviews

2 Answers   Ordain Solutions,

Explain in brief about the QTP Automation Object Model.

1 Answers  

What are they Advantages and Disadvantages in QTP 9.2?

1 Answers   Infotech,

How can we close all webbrowsers which are opened in out desktop?

3 Answers  

what questions i have to pripare for project manager round interview ? plz give Ans.(Chandana)

5 Answers   TCS,

what r advance features u had done in QTP?

3 Answers   HCL,

What is parameter in qtp?

0 Answers  

Explain about merging of two repositories?

3 Answers  

what r the 3 basic factor on which we determine to perform automation

6 Answers   AppLabs,

How to find local host name using QTP?

6 Answers  

For more QTP Interview Questions Click Here
Categories