Data Pool connection in Test partner
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
Thanks in Advance !
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.