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, and .NET 7.0, and .NET 9.0. The provider supports .NET Core 2.x and 3.x.

IDE Compatibility

dotConnect Universal can be used with following integrated development environments:

  • Microsoft Visual Studio 2008-2022
  • 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 versions 8-17, 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.

Supported Providers

The following table contains the names and descriptions of the data providers natively supported by dotConnect Universal:

Provider Name Description
.NET Framework Data Provider
for SQL Server		 SQL Server The .NET Framework Data Provider for SQL Server uses its own protocol to communicate with SQL Server. It is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer. For more information refer to the Using dotConnect Universal with SQL Client topic.
.NET Framework Data Provider
for OLE DB		 OLE DB The .NET Framework Data Provider for OLE DB uses native OLE DB through COM interop to enable data access.
Note that OLE DB providers has their own connection string parameter Provider. To avoid the conflict, you have to use ole db provider connection string parameter to specify the specific OLE DB provider. For example, OLEDB connection to Oracle server can look as follows: provider=OLE DB;ole db provider=OraOLEDB.Oracle;Data Source=ora;Password=tiger;User ID=scott.
.NET Framework Data Provider
for ODBC		 ODBC The .NET Framework Data Provider for ODBC uses native ODBC Driver Manager through COM interop to enable data access.
.NET Framework Data Provider
for Oracle		 OracleClient The .NET Framework Data Provider for Oracle enables data access to Oracle data sources through Oracle client connectivity software. The data provider supports Oracle client software version 8.1.7 and later.
Microsoft Access Provider MS Access The provider for MS Access enables data access to Microsoft Access data sources through OLE DB. Recommended for single-tier applications using Microsoft Access databases.
dotConnect for Oracle Data Provider Oracle dotConnect for Oracle provides direct access to Oracle database server with or without the Oracle Call Interface (OCI). The data provider supports Oracle Client software version 8.0 and later. For more information refer to the Using dotConnect Universal with dotConnect for Oracle topic.
dotConnect for MySQL Data Provider MySQL dotConnect for MySQL is data provider for direct access to MySQL database server for the Microsoft .NET Framework. Data provider can access MySQL server either using native MySQL network protocol directly or through MySQL client library. For more information refer to the Using dotConnect Universal with dotConnect for MySQL topic.
dotConnect for PostgreSQL
Data Provider		 PostgreSQL dotConnect for PostgreSQL is data provider for direct access to PostgreSQL database for the Microsoft .NET Framework. Data provider uses native message-based protocol for communication with PostgreSQL database server. For more information refer to the Using dotConnect Universal with dotConnect for PostgreSQL topic.
dotConnect for SQLite Data Provider SQLite dotConnect for SQLite is data provider for direct access to SQLite database for the Microsoft .NET Framework. Data provider allows you to use full capabilities of the SQLite database engine and all SQLite data types. For more information refer to the Using dotConnect Universal with dotConnect for SQLite topic.
Oracle Data Provider for .NET ODP The Oracle Data Provider for .NET enables data access to Oracle data sources through Oracle client connectivity software. The data provider supports Oracle client software version 9.2 and later.
IBM DB2.NET Data Provider DB2 The DB2 .NET Data Provider allows your .NET applications to access Version 8 and higher DB2 Universal Database on Windows, UNIX, and Linux-based computers, and Version 6 or later of DB2 for OS/390 and z/OS via DB2 Connect.
Firebird ADO.NET Provider FirebirdClient The .NET Data Provider for Firebird 1.x, 2.0, and InterBase 6.0 databases. Available for .NET Framework 2.0 only.
We have created a sample wrapper code for Firebird provider for Firebird 2.5 and 3.0, that can be used in dotConnect Universal via its extensibility mechanisms.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.