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 support@logigear.com.
  • 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:
Built-in methods that you can use as operations on objects of class AbtDatabase: