Results 1 to 2 of 2
  1. #1

    Data Pool connection in Test partner

    Hi ,

    Is it possible Data Pool connection in Test partner 6.0 Software ?.

    Currently i am using Oracle 10 g for keeping Expected data and while running the script.Test partner will interact with respective table and through the SQL Query TP will get the respective column value to a string and populate the value to the sceen.

    Note : Through the ODBC I have created the DSN Name with UesrName and Password . for each execution SQL Query in my script I will going to call this Data base connection function. from this i think Performance of script is reduced. is there any other way to improve the performance of the script .

    Please find the script below.


    Public Function Connect()

    Set cnn = New Connection

    On Error GoTo ErrorHandler

    'Get the DSN_Name from the Shared Module

    cnn.ConnectionString = "DSN=OracleTestdata;UID=tptestdata;PWD=tptestd ata"


    'If the ODBC Connection is not done, throw the Error Description


    If (Err.Description <> "") Then

    UserCheck "DataBase_Queries", False, Name & Err.Number & Err.Description


    UserCheck "DataBase_Queries", True, Name & Err.Number & Err.Description

    End If

    End Function


    Thanks in Advance !


  2. #2

    Re: Data Pool connection in Test partner

    If your connection is declared with the proper public scope and opened when you start a test run, it will be available in every script.

    Individual scripts only need to open a SQL recordset through the connection.

    You should also explicitly close the connection when the run is finished.

    Also, in your error handling above you can test the success of the Open method with something like

    "If cnn.State = adStateOpen Then"

    and any errors will be available in a collection:

    "For Each dbErrors In cnn.Errors"

    This collection has additional properties that can help you track down the cause of a database error.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 03:54 PM.

Copyright BetaSoft Inc.