Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

dotConnect Universal Compatibility

.NET Framework Compatibility

The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7 and .NET Compact Framework 2.0. Note that .NET Framework 1.0 and 1.1 is not supported.

IDE Compatibility

dotConnect Universal can be used with following integrated development environments:

  • 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 12c, 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions;
    • dotConnect Universal supports both x86 and x64 versions of the following Oracle clients: 12c, 11g, 10g, 9i, 8i and 8.0.
  • Microsoft SQL Server

    dotConnect Universal supports SQL Server 2014, 2012, 2008, 2005 (including Express editions), SQL Server 2000 and MSDE.

  • MySQL

    dotConnect Universal supports MySQL server versions 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. dotConnect Universal supports Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon RDS for Aurora.

  • PostgreSQL

    dotConnect Universal supports PostgreSQL server since 7.1 version to 10, 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, and 2007.

  • 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.