Description
The ADODriver
object is a DDT driver object that provides access to data stored in a recordset that can be accessed via ADO DB. The recordset can be a database table or a result of executing the SELECT
SQL statement.
To obtain the ADODriver
objects in scripts, call the ADODriver
method of the DDT
object.
Members
Example
The code below connects to the specified database, retrieves information about the name of the command used by the database's myTable table, posts this name to the test log and then closes the connection to the database.
Note: |
Using the Microsoft.Jet.OLEDB.4.0 provider requires that you run your script in the 32-bit version of TestComplete. TestComplete 32-bit executable is located in the <TestComplete>\Bin folder. |
JavaScript, JScript
function ADODriverExample()
{
// Specifies the connection string
var ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Microsoft Visual Studio\\VB98\\biblio.mdb";
// Specifies the name of the table
var tName = "myTable";
// Obtains the ADO Command object name
var cName = DDT.ADODriver(ConStr, tName).ADOCommandObject.Name;
// Posts this name to the test log
Log.Message(cName);
// Closes the connection to the specified database
DDT.ADODriver(ConStr, tName).ADOConnectionObject.Close();
}
Python
def ADODriverExample():
# Specifies the connection string
ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Microsoft Visual Studio\\VB98\\biblio.mdb"
# Specifies the name of the table
tName = "myTable"
# Obtains the ADO Command object name
cName = DDT.ADODriver(ConStr, tName).ADOCommandObject.Name
# Posts this name to the test log
Log.Message(cName)
# Closes the connection to the specified database
DDT.ADODriver(ConStr, tName).ADOConnectionObject.Close()
VBScript
Sub ADODriverExample
' Specifies the connection string
ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
"Data Source=C:\Microsoft Visual Studio\VB98\biblio.mdb"
' Specifies the name of the table
tName = "myTable"
' Obtains the ADO Command object name
cName = DDT.ADODriver(ConStr, tName).ADOCommandObject.Name
' Posts this name to the test log
Log.Message(cName)
' Closes the connection to the specified database
DDT.ADODriver(ConStr, tName).ADOConnectionObject.Close
End Sub
DelphiScript
function ADODriverExample;
var ConStr, tName, cName;
begin
// Specifies the connection string
ConStr := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=C:\Microsoft Visual Studio\VB98\biblio.mdb';
// Specifies the name of the table
tName := 'myTable';
// Obtains the ADO Command object name
cName := DDT.ADODriver(ConStr, tName).ADOCommandObject.Name;
// Posts this name to the test log
Log.Message(cName);
// Closes the connection to the specified database
DDT.ADODriver(ConStr, tName).ADOConnectionObject.Close();
end;
C++Script, C#Script
function ADODriverExample()
{
// Specifies the connection string
var ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Microsoft Visual Studio\\VB98\\biblio.mdb";
// Specifies the name of the table
var tName = "myTable";
// Obtains the ADO Command object name
var cName = DDT["ADODriver"]( ConStr, tName )["ADOCommandObject"]["Name"];
// Posts this name to the test log
Log["Message"](cName);
// Closes the connection to the specified database
DDT["ADODriver"](ConStr, tName)["ADOConnectionObject"]["Close"]();
}
See Also
Using DDT Drivers
Data-Driven Testing - Basic Concepts
Data-Driven Testing - Retrieving Input Data From Storage
DDT Object
DDTDriver Object