Results 1 to 3 of 3

Thread: Data Base Testing using QTP 9.2.

  1. #1
    Contributing Member
    Join Date
    Aug 2007
    Answers
    59

    Data Base Testing using QTP 9.2.

    i want o know the steps involved in testing a DATABASE using QTP 9.2.

    thanks in advance!!!
    raj


  2. #2

    Re: Data Base Testing using QTP 9.2.

    For doing database validation using QTP you have to do the following
    a. Insert database check points to validate the records as per the specifications
    b. You can write the SQL queries in QTP to do the retrieval, insertion, updation or deletion of records.
    c. QTP scripts has to be written along with the SQL queries for doing database testing


  3. #3
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

    Smile Re: Data Base Testing using QTP 9.2.

    Hi Raj,

    Database testing using QTP would look something like this -

    DSNLess
    dim sCon
    dim sRec
    set sCon = CreateObject("ADODB.Connection")
    sCon.Provider = "Microsoft.Jet.OLEDB 4.0"
    sCon.connectionString = "DataSourceName = ;UserId = ;Pwd = ;InitialCatalog="
    sCon.Open
    set sRec = CreateObject("ADODB.Recordset")
    sRec.Open "Select * from Table_Name {Conditions}",sCon, adOpenDynamic

    Get the individual values stored in sRec using a for loop.

    sRec.fields(0) - would fetch the first value stored in the sRec Object.

    Cheers.....


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact