ADODriver Object

Applies to TestComplete 12.60, last modified on September 17, 2018

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.

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

Highlight search results