AbtDatabase

Object class representing a SQL-compliant database.

Notes

• At present, AbtDatabase methods are available only for the C# harness.

• Supported databases:

  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012
  • MySQL 5.6.20
  • Microsoft Excel 2007, 2010, and 2013
  • Oracle Database:
    • Oracle Database Enterprise Edition
      • 12c Release 2
      • 11g Release 2
    • Oracle Database Express Edition
      • 11g Release 2
  Note:
  • SQL Server and MySQL are standard relational database management systems (DBMSs) that enjoy widespread use. While MS Excel is not a DBMS per se, its data is also structured in a relational (table) form, allowing for it to also be queried by means of SQL commands.
  • In principle, while only the DBMSs listed are explicitly supported, any SQL-conversant DBMS with ODBC-compliant drivers for the platform of the given test system should also behave well with TestArchitect. For assistance, contact TestArchitect Support at [email protected].

• Connecting to and querying a database from a test requires that the correct ODBC driver be used. The correct driver must be specific to both the database application and the architecture (32-bit¹ or 64-bit) of the TestArchitect Controller application that uses it. The following utilities may be used to determine whether the correct driver is already installed:

  • Windows: Open the ODBC Data Source Administrator dialog box. A list of installed ODBC drivers is available under the Drivers tab. (Learn more.)

    

    Note:
    On the 64-bit version of Windows, only the 64-bit ODBC drivers are displayed in this tool. If your 64-bit Windows system should happen to be running a 32-bit¹ version of the TestArchitect Controller software, you need to ensure that the 32-bit¹ ODBC driver is installed. You can check this by directly running the 32-bit¹ version of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool, which is found at %systemdrive%\Windows\System32\Odbcad32.exe. (Learn more.)

  • macOS and Linux: If you do not already have a utility that lists installed ODBC drivers, one good option is the open source project unixODBC.

• Should you need to obtain the ODBC driver installer for your particular data source, following the appropriate link below:

  • Microsoft SQL Server:

    • On Windows: Read here.
    • On Linux: Read here.
    • On macOS: Microsoft does not provide a SQL Server ODBC driver for the macOS machine. However, a good open source alternative, FreeTDS, is available. Note that, additional configurations are also required (learn more).

  • MySQL Server: Read here.

    Note:
    On macOS, additional configurations are required (learn more).

  • Excel: The ODBC driver for Microsoft Excel is automatically installed with Microsoft Office. If Microsoft Office is not currently installed on your test machine, you can download and install the correct driver from the appropriate link below:

    • ODBC driver for Excel 2007 (32-bit¹): http://www.microsoft.com/en-us/download/details.aspx?id=23734
    • ODBC driver for Excel 2010 (both 32¹ and 64-bit): http://www.microsoft.com/en-us/download/details.aspx?id=13255
    • ODBC driver Excel 2013 (32-bit¹): http://www.microsoft.com/en-us/download/details.aspx?id=39358

Built-in methods that you can use as operations on objects of classAbtDatabase:

Connect

Disconnect

ExecSqlCommand