SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Oct 2004
    Location
    india
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    How to connect rational robot to Oracle Database

    want code to connect rational robot to oracle database
    navinskumar

  2. #2
    Senior Member
    Join Date
    Oct 2001
    Location
    India
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to connect rational robot to Oracle Database

    You can use the SQL* functions of Robot to execute SQL queries on a database.
    Sachin Lalye

  3. #3
    Senior Member
    Join Date
    Sep 2004
    Location
    Ashland, ma, USA
    Posts
    275
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to connect rational robot to Oracle Database

    I am also interested in this question.
    Sachin Lalye, could you give a short script example.
    How Robot knows that this is Oracle DB?
    For what kind of testing Robot is conected to DB?

    Thank you

  4. #4
    Junior Member
    Join Date
    Dec 2001
    Location
    Winnipeg, Manitoba, Canada
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to connect rational robot to Oracle Database

    Robot doesn't care what kind of DB it is, as long as there is an ODBC connection. use the same SQL commands to retrieve data from the database. ie: SQLRequest "DSN=(DNSName);UID=(userID);PWD(password used to connect to ODBC), query (declared string that has the executable command), , , , Value() (array variant to retrieve the value from the query)

  5. #5
    Junior Member
    Join Date
    Sep 2004
    Location
    Sacramento
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to connect rational robot to Oracle Database

    Don't know if this helps, but here is what I use to connect to a SQL db. I think the same idea pertains to an Oracle db...

    'Make a backend SQL DB connection******
    'open the connection
    connection = SQLOpen("DSN=qaqc-billing; UID=sa; PWD=",prompt:=4)

    'Prompt 4 does the connection in the backend, so there is no user action/input.

    'Get the RunNum variable
    query = "SELECT BLSTGKEY FROM QAQC_Billing.IMSV7.BLSTG ORDER BY BLSTGKEY DESC"

    RetCode = SQLExecQuery(connection,query)

    RetCode = SQLRetrieve(connection:=connection,destination:=de stination(),columnNames:=0,rowNumbers:=0,maxRows:= 1,maxColumns:=1,fetchFirst:=0)

    RunNum=destination(1,1)

    RetCode = SQLClose(connection)

    Print RunNum

  6. #6
    Junior Member
    Join Date
    Jun 2005
    Location
    Malaysia
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to connect rational robot to Oracle Database

    try using this statement.


    Dim conn As object
    Dim rs As object
    Dim strsql as string

    Set conn = CreateObject("ADODB.Connection")
    Set rs = CreateObject("ADODB.Recordset")

    conn.open "Provider=MSDAORA.1;User ID=YourUserID;Data Source=YourDBName;Persist Security Info=True","YourUserID","YourPassword"

    strsql="select something from some table"
    conn.execute strsql

 

 

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 8.57%
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 05:51 PM.

Copyright BetaSoft Inc.