SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 8 of 8
  1. #1
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Few basic queries

    User win som (s_runwin@yahoo.com.nospam) posted:

    --0-1533402437-1031388553=:38527
    Content-Type: text/plain; charset=us-ascii


    hello friends...........i am new to WR and write now just going through its help manual......well i have few queries........can u guys help me....

    1.My application use VB and Oracle,it is also using Third Party Controls [Protoview Suite]..now my question is whether i can use wr for testing ..will it recognize the Third Party Controls....and how will i do it?

    2.Well can use Oracle for database driven test....or it only MS Access that i can use.......?????

    .........well i will really appreciate if u guys can explain this to me....

    take care

    saksham
    ---------------------------------

  2. #2
    Junior Member
    Join Date
    Mar 2002
    Location
    Noida, U.P., India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    as far as ur second query is concerned i think it works for all DB all u need to install the Oracle Client in the m/c from where you are using winrunner and create a DSN then connect to db using this DSN name use database functions from winrunner..

    try this way.
    regards,
    Pooja.

    ------------------

  3. #3
    Senior Member
    Join Date
    May 2001
    Posts
    378
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User Lior Dekel (ldekel@pillardata.com.nospam) posted:

    ------_=_NextPart_001_01C257F0.8F688DF4
    Content-Type: text/plain;
    charset="iso-8859-1"
    Content-Transfer-Encoding: quoted-printable

    Hello Saksham,
    You can use several dB's with WinRunner example: SQL, ORACLE, ACCESS and I =
    think there is another one but I forgot the name.
    If you are using VB controls you may want to load WR with the VB add on che=
    cked. Also you may want to use ActiveX control add on if it may help you wi=
    th your ProtoView controls but I am not sure of that since I do not know th=
    ese controls. The best method is to try running GUI Spy or even recording a=
    simple action and see how WR reacts to this.
    =20
    Regarding the dB's, I have used an Oracle dB before but not for the use of =
    a data table (like you would use an Excel spreadsheet) rather to verify my =
    expected results. I.E. I made an action in the AUT, it is supposed to make =
    a change in the dB, I connect to the dB using WR and run a SQL query on the=
    dB to check & verify my expected results.
    =20
    Hope this helps.
    LIOR
    =20

    If it's working... don't touch it!

  4. #4
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User win som (s_runwin@yahoo.com.nospam) posted:

    --0-1586546329-1031570595=:5931
    Content-Type: text/plain; charset=us-ascii



    thanks lior ,it was indeed of great help........i will try these options.........but how do u connect Oracle through WR.??.......coz i have read only about WR-Excel connection till now?.......what is the way to do that........?.......do mail me
    thanks again
    take care
    saksham
    ---------------------------------

  5. #5
    Junior Member
    Join Date
    Feb 2002
    Location
    Hyderabad, AP, India
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User ANIL K. REDDY (anilrk@solutionsoftware.com.nospam) posted:

    ------_=_NextPart_001_01C257F4.77CAD154
    Content-Type: text/plain;
    charset="iso-8859-1"
    Content-Transfer-Encoding: quoted-printable

    Using the "DSN" u can connect to the database..
    map a system DSN with ur Oracle Database and use the DSN name in db_connec=
    t function
    Ex:=20
    =20
    db_connect ("query1","DSN=3DFlight32");=20
    =20

    Thanks and Regards,=20
    Anil Reddy=20


  6. #6
    Senior Member
    Join Date
    May 2001
    Posts
    378
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User Lior Dekel (ldekel@pillardata.com.nospam) posted:

    ------_=_NextPart_001_01C257F6.3479F532
    Content-Type: text/plain;
    charset="iso-8859-1"
    Content-Transfer-Encoding: quoted-printable

    No prob...
    To connect to any dB's you use you must first have your dB admin have your =
    machine configured properly for this connection.
    I remember when I used Oracle with WR I needed two DLL files in my WinNT fo=
    lder.=20
    Normally you use db_connect() statement from WR to connect to your dB. Look=
    at this command it has several other params , like user name & password fo=
    r the dB.
    Then you use db_execute_query() and put your SQL statement there to extract=
    values from the db.
    This is it more or less ...
    Regarding the Excel spreadsheets, well that is not exactly a dB but only a =
    simple way to store data that is bound to chage frequently and you do not w=
    ish to hard code it all the time.
    =20
    LIOR
    =20

    If it's working... don't touch it!

  7. #7
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User liorka2001 (liorka@amdocs.com.nospam) posted:

    This is a message to Lior Dekel can you send me you mail address?

    Lior

    --- In winrunner@y..., win som <s_runwin@y...> wrote:
    options.........but how do u connect Oracle through WR.??.......coz i
    have read only about WR-Excel connection till now?.......what is the
    way to do that........?.......do mail me



  8. #8
    Senior Member
    Join Date
    Jun 2002
    Location
    Hadera, Israel
    Posts
    313
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Few basic queries

    User Roman Zilber (romanz@enigma.com.nospam) posted:

    ------_=_NextPart_001_01C257F7.3827B460
    Content-Type: text/plain;
    charset="iso-8859-1"

    I can:
    Lior Dekel [ldekel@pillardata.com]
    ;-)


 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.71%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 03:53 AM.

Copyright BetaSoft Inc.