SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Apprentice
    Join Date
    Jul 2004
    Location
    WA, USA
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    not able to connect to Oracle DB using lr_db_connect

    Hi All,

    First of my environment information:

    HP LoadRunner Software 11.04
    Product Version: 11.04.0.0
    Product Build: Build 9409

    Installed Components:
    Analysis :11.04.0.0
    Online Documentation: 11.04.0.0
    Samples: 11.04.0.0
    Vuser Generator: 11.04.0.0

    Installed Patches:
    LRVUG_00002 for HP Vugen SA 11.00 QFE
    HP Virtual User Generator 11.00 Patch 4
    LRVUG_00045 for HP LoadRunner 11.00
    HP Analysis 11.00 Patch 4

    Protocols: Web 2.0

    I am trying to connect to Oracle DB using lr_db_connect but getting following error.

    my code

    vuser_init()
    {
    lr_db_connect("StepName=ConnectionToDB",
    "ConnectionName=DB1",
    "ConnectionString=Provider=OraOLEDB.Oracle.1;D ata Source=<TNS name from TNSNames.ora file>;User ID=<MyUID>;Password=<mYPassword>",
    "ConnectionType=OLEDB",
    LAST);
    return 0;
    }

    Virtual User Script started at : 2014-03-26 15:51:25
    Starting action vuser_init.
    vuser_init.c(16): DB Connection "ConnectionToDB" started ... Wait ....
    vuser_init.c(16): Error: DB Connection failed {"The 'OraOLEDB.Oracle.1' provider is not registered on the local machine."}
    vuser_init.c(16): Error: DB Connection failed {"ConnectionToDB"}
    Abort was called from an action.

    Debugging done so far:
    1. Verified the Oracle client path. This is set correctly.
    C:\app\<myName>\product\11.2.0\client_1;C:\app\<my Name>\product\11.2.0\client_1\bin

    2. Registered the OraOLEDB11.dll correctly.

    3.TNSname.ora file is upto date.

    4. Created function in Web Services scripts protocol using Insert -> New Step -> Database: Connect

    5. Oracle home is set correctly.

  2. #2
    Moderator
    Join Date
    Aug 2001
    Location
    NC
    Posts
    6,018
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0
    Recorded or hand coded? If hand coded then you will want to record SQL+ and look at the structural differences in the scripts, including the behind the scenes data structures which get created but which do not appear in the core script.
    James Pulley

    Replace ineffective offshore contracts, LoadRunnerByTheHour. Starting @ $19.95/hr USD.

    Put us to the test, skilled expertise is less expensive than you might imagine.

    Twitter: @LoadRunnerBTH @PerfBytes

  3. #3
    Apprentice
    Join Date
    Jul 2004
    Location
    WA, USA
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Hi James,

    Thank you for you reply. This script is hand coded in Web Services scripts protocol using Insert -> New Step -> Database: Connect. And using the Connection Dialog to create a database specific connection string.

    I tired recording SQL plus, SQl Developer using Oracle (2-Tier) protocol.
    1. SQL Plus didn't launch at all. (Application Type win 32, program to record: SQL Plus exe path, Program arguments: blank, Working directory: Vugen bin directory path, record into Action: vuser_init)
    2. SQL developer:
    (Application Type win 32, program to record: SQL developer exe path, Program arguments: blank, Working directory: SQL developer directory path, record into Action: vuser_init)

    Application was able to launch, but nothing got recorded.

    Any pointer?

    Thank You!

  4. #4
    New Member
    Join Date
    Jun 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Maverick, were you able to find a solution for this? Please share if found.

 

 

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 06:49 PM.

Copyright BetaSoft Inc.