ConnectionString Property

Applies to TestComplete 15.47, last modified on January 20, 2023

Description

Use the DBTable.ConnectionString property to obtain or specify the connection settings, which TestComplete will use to connect to the database, whose data should be compared with the DBTable project element that corresponds to the DBTable object.

You can use the property to specify a database that contains the data you want to compare and the database engine. The name of the database table must be the same as the name of the table, which you use to create the DBTable project element. For example, if the DBTable element was created for the Orders table, then the database specified by the ConnectionString property must contain the Orders table. Else, an error will occur.

Declaration

DBTableObj.ConnectionString

Read-Write Property String
DBTableObj An expression, variable or parameter that specifies a reference to a DBTable object

Applies To

The property is applied to the following object:

Property Value

String that specifies the connection settings.

Example

The code below specifies a connection string - the login and password that will be used to connect to a database. After that, the routine connects to this database and compares its content with stored data.

Notes:

  • This sample uses Jet OLE DB Provider 4.0 to connect to the database. If you use another version of Microsoft Jet, just replace the version number in the code.

  • Using the Microsoft.Jet.OLEDB.4.0 provider requires that you run your script in the 32-bit version of TestComplete.

JavaScript, JScript

function ConStringExample()
{
  // Specifies a DB Table element
  var DBTab = DBTables.Table1;
  
  // Specifies a connection string
  DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
  "Data Source=C:\\Work\\MyDB.mdb;";
  // Specifies the login and password
  DBTab.Login = "Tester";
  DBtab.Password = "123";
  
  // Connects to the database using
  // the specified connection parameters
  // and compares its content with stored data
  DBTab.Check;
  
}

Python

def ConStringExample():
  # Specifies a DB Table element 
  DBTab = DBTables.Table1
  # Specifies a connection string 
  DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Work\\MyDB.mdb;"
  # Specifies the login and password 
  DBTab.Login = "Tester"
  DBTab.Password = "123"
  # Connects to the database using 
  # the specified connection parameters 
  # and compares its content with stored data 
  DBTab.Check()

VBScript

Sub ConStringExample

  ' Specifies a DB Table element
  Set DBTab = DBTables.Table1
  
  ' Specifies a connection string
  DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
  "Data Source=C:\Work\MyDB.mdb;"
  ' Specifies the login and password
  DBTab.Login = "Tester"
  DBtab.Password = "123"
  
  ' Connects to the database using
  ' the specified connection parameters
  ' and compares its content with stored data
  DBTab.Check
  
End Sub

DelphiScript

function ConStringExample();
var DBTab;
begin

  // Specifies a DB Table element
  DBTab := DBTables.Table1;
  
  // Specifies a connection string
  DBTab.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
  'Data Source=C:\Work\MyDB.mdb;';
  // Specifies the login and password
  DBTab.Login := 'Tester';
  DBtab.Password := '123';
  
  // Connects to the database using
  // the specified connection parameters
  // and compares its content with stored data
  DBTab.Check;
  
end;

C++Script, C#Script

function ConStringExample()
{
  // Specifies a DB Table element
  var DBTab = DBTables["Table1"];
  
  // Specifies a connection string
  DBTab["ConnectionString"] = "Provider=Microsoft.Jet.OLEDB.4.0;" +
  "Data Source=C:\\Work\\MyDB.mdb;";
  // Specifies the login and password
  DBTab["Login"] = "Tester";
  DBtab["Password"] = "123";
  
  // Connects to the database using
  // the specified connection parameters
  // and compares its content with stored data
  DBTab["Check"];
  
}

See Also

About Database Checkpoints
Login Property
Password Property

Highlight search results