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

How to get all the objects count and objects names in webpage using QTP ?

6 Answers  

What are the most frequent errors you faced while executing your scripts?

4 Answers   Semantic Space,

how to write scripts in QTP?

4 Answers   Ordain Solutions,

is qtp 9.2 create the scripts with the application run on mozilla firefox browser?

3 Answers  

I want some banking domain projects where can i get this projects ( anybody can help me plz)

3 Answers  

What is InStr()

6 Answers   Kanbay,

how do u import the test cases written in excel sheet to qtp? and how do u generate the script in qtp for the testcase in excel sheet? plzzzz do answer this question thanks in advance

4 Answers  

Pls let me know how to find out creation time and index for the web application in descriptive programming?

2 Answers   HP,

How to handle exception when data table is not available in local host system or path is not correct(explain statement with example)

1 Answers  

how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script

5 Answers   Cap Gemini,

what are the mandatory properties in qtp? what are the library functions in qtp?

3 Answers   Wipro,

How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

2 Answers  

For more QTP Interview Questions Click Here
Categories