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 API?

1 Answers  

What is the Difference between current version of QTP and QTP 8.2. Pls kidly Anybody let me know. Thanks in advance.

1 Answers   TCS,

If I change the object name in one action will it be updated in all the actions? Or not?

0 Answers  

What are the properties you would use for identifying a browser and page when using descriptive programming?

0 Answers  

Hi Friends, Every one is posting the Answers for the existing questions.Try to post the questions that are asked in Recent Interviews.It will be useful to the other Job seekers.

1 Answers  

How to convert QTP's ObjectRepository.mdb file to xml file

1 Answers  

how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?

8 Answers   INCA, Infosys, Logix, SLK Software, Symphony, Wipro,

For Regression testing already written test cases are sufficient?

2 Answers   CTS,

QTP WAS WORKING FINE BUT TODAY I GOT THE ERROR , THE MEMORY COULD NOT BE READ -REFERENCE MEMORY ,pPLEASE REPLY URGENT WHAT IS THE SOLUTON

1 Answers  

I am trying to install QTP 9.5 but i am getting error message saying that ("Path is \QuickTest Professional\bin\vb_init.exe") vb_init.exe file is not find. can anybody give me the advise what to do ?

0 Answers  

can we install qtp in windows vista

2 Answers  

Inserting a Call to Action is not Importing all columns in Datatable of globalsheet. Why?

4 Answers   Accenture,

For more QTP Interview Questions Click Here
Categories