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

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close