Skip to main content

Data Providers

You may have to install a free third party component to access your specific platform. Look for the entries in red in your File – Data Providers form, with registered ADO.NET Data Providers. After you install a specific data provider for your platform, restart the application and look for your new installed provider.

MySQL, MariaDB and Amazon Aurora

  • If we cannot find MySql.Data.MySqlClient.
  • Download and run the free Connector/Net MSI installer from MySQL’s website.
  • This should register the MySQL Data Provider (.Net Framework Data Provider for MySQL) on your machine.

PostgreSQL and Amazon Redshift

  • If we cannot find Npgsql.
  • Download and run the free Npgsql MSI installer from github.
  • This should register the Npgsql Data Provider (.NET Data Provider for PostgreSQL) on your machine.

Oracle

  • If we cannot find Oracle.ManagedDataAccess.Client.
  • Download and unzip the free ODP.NET_Managed file from Oracle’s website.
  • This should register the ODP.NET, Managed Driver (Oracle Data Provider for .NET, Managed Driver) on your machine.

Microsoft SQL Server and Microsoft Azure SQL Database

  • If we cannot find System.Data.SqlClient.
  • You should upgrade your .NET Framework to 4.0 or higher.
  • This should register the SqlClient Data Provider 4.0 (.Net Framework Data Provider for SqlServer) on your machine.
  • As an alternative, download and install a free version of SQL Server Express.

Microsoft SQL Server CE

  • If we cannot find System.Data.SqlServerCe (which should be included in the .NET Framework).
  • Download and run the free Microsoft SQL Server Compact 4.0 from Microsoft’s website.
  • This should register the Microsoft SQL Server Compact Data Provider 4.0 (.NET Framework Data Provider for Microsoft SQL Server Compact) on your machine.

Microsoft Access

  • You must have Microsoft Access installed on your computer.
  • If we cannot find System.Data.OleDb, or one of  the OLE DB providers for Access Microsoft.Jet.OLEDB.4.0 (for MDB files) or Microsoft.ACE.OLEDB.12.0 (for ACCDB files, since MS Access 2007).
  • Download and install the free Microsoft Access Database Engine 2010 Redistributable (for x32) from Microsoft’s website.
  • This should register the OleDb Data Provider (.Net Framework Data Provider for OleDb) and the MS Access OLE DB providers on your machine.

Sybase/SAP ASE

Sybase/SAP SQL Anywhere

  • If we cannot find iAnywhere.Data.SQLAnywhere.
  • Download and run the free SQL Anywhere Windows Client (x64 on Vista 64 or above) from SAP’s website.
  • This should register the SQL Anywhere 16 Data Provider (.Net Data Provider for SQL Anywhere 16) on your machine.

IBM DB2

  • If we cannot find IBM.Data.DB2.
  • Download and install the IBM Data Server Driver Package (DS Driver) from IBM’s website.
  • This should register the IBM DB2 .NET Data Provider (IBM DB2 Data Provider for .NET Framework 4.0) on your machine.

Ingres

  • If we cannot find Ingres.Client.
  • Download, unzip and run the free Ingres .NET Data Provider from Actian’s website.
  • This should register the Ingres Data Provider (.NET Data Provider for Ingres) on your machine.

SQLite

  • There is no need of a third party data provider for SQLite.
  • We use a built-in driver, distributed and installed automatically with our own product.

Firebird

  • If we cannot find FirebirdSql.Data.FirebirdClient.
  • Download and run the free Firebird ADO.NET MSI installer from Firebird’s website.
  • This should register the FirebirdClient Data Provider (.NET Framework Data Provider for Firebird) on your machine.

Leave a Reply