dotConnect Universal Compatibility

.NET Framework Compatibility

The provider works with .NET Frameworks 4.0, 4.5, 4.6, 4.7, and 4.8, .NET 5.0, .NET 6.0, .NET 7.0, and .NET 8.0. The provider supports .NET Core 2.x, 3.x.

IDE Compatibility

dotConnect Universal can be used with following integrated development environments:

  • Microsoft Visual Studio 2022 release and preview
  • Microsoft Visual Studio 2019
  • Microsoft Visual Studio 2017
  • Microsoft Visual Studio 2015
  • Microsoft Visual Studio 2013
  • Microsoft Visual Studio 2012
  • Microsoft Visual Studio 2010
  • Microsoft Visual Studio 2008
  • Embarcadero Delphi Prism
  • CodeGear RAD Studio 2007

 

 

There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and DDEX integration. As an exclusion, Visual Web Developer 2008 and 2010 supports DDEX features.

RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.

Database Server Compatibility

Currently dotConnect Universal supports the following databases:

  • Oracle

    • dotConnect Universal supports Oracle servers 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, and 8.0, including Personal and Express editions;
    • dotConnect Universal supports both x86 and x64 versions of the following Oracle clients: 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i and 8.0.
  • Microsoft SQL Server

    dotConnect Universal supports SQL Server SQL Azure, SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 (including Express editions), SQL Server 2000 and MSDE.

  • MySQL

    dotConnect Universal supports MySQL server versions 8.0, 5.7, 5.6, 5.5, 5.4, 5.1, 5.0, 4.1, 4.0 and 3.23 including Embedded servers (starting with 4.1), 64-bit MySQL servers, Percona, and MariaDB (version 11, 10, 5). dotConnect Universal supports Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon RDS for Aurora.

  • PostgreSQL

    dotConnect Universal supports PostgreSQL server since 8 version to 16, EnterpriseDB, Pervasive Postgres SQL servers, Heroku Postgres.

  • SQLite

    dotConnect Universal supports SQLite engine version 3 and higher.

  • InterBase

    • InterBase: versions 6.x and higher;
    • Firebird: versions 2.x, 1.x;
    • Yaffil.
  • DB2

    • DB2 for LUW: 8.0 and higher;
    • DB2 for OS/390 and z/OS via DB2 Connect: 6 and higher.
  • Microsoft Access

    version 95, 97, 2000, 2003, 2007, 2010, 2013, 2016, 2019, and 2021E.

  • Sybase Adaptive Server Enterprise

    Sybase Adaptive Server Enterprise servers and clients: 11.0 and higher.

  • Sybase Advantage Database Server

    • Sybase Advantage Database Server servers: 8.0 and higher;
    • Client (Sybase Advantage ODBC driver): 8.0 and higher.

Note: dotConnect Universal supports any database using ODBC provider.