Data Connectivity
SQLite Database Encryption Issue
This article is for dotConnect for SQLite. When working with SQLite databases in applications built with dotConnect for SQLite, built-in encryption may fail to work. This usually happens either because of edition limitations or because the wrong ...
Working with Salesforce Attachments
This article is for SSIS Data Flow Components for Salesforce. SSIS Data Flow Components for Salesforce can be used to download and upload Salesforce attachments. To work with documents (binary files), the ContentVersion object is required. The binary ...
Devart SSIS Components Missing in Integration Services
This article is for SSIS Data Flow Components. After installing Devart SSIS Data Flow Components, the components may not appear in Integration Services projects inside Visual Studio. This typically happens when the project configuration does not ...
Excel Automation
This article is for Excel Add-ins. The scenario involves building an automation system based on Devart Excel Add-ins, with data transfer between different sources, synchronization, and automatic data updates. Solution Devart Excel Add-ins are ...
Loading Data from Excel
This article is for Excel Add-ins. Excel Add-ins can be used to work with external data sources and update data directly in Excel. A common question is whether it is possible to load arbitrary data from an Excel worksheet into a connected database or ...
Excel Add-ins. Slow Data Extraction (Cloud Providers)
This article is for Excel Add-ins (Clouds). Navigation: Supported Data Sources → Supported cloud applications: When working with Excel Add-ins connected to cloud sources such as Salesforce or QuickBooks, data loading may be noticeably slower than ...
Excel Add-ins. Slow Data Extraction (Database Providers)
This article is for Excel Add-ins (Databases). Navigation: Supported Data Sources → Supported databases: Data loading into Excel may work noticeably slower compared to executing the same query in other tools. Performance can be improved by adjusting ...
How to Enable Nullable Reference Types in Entity Developer Models
This article is for dotConnect providers with ORM support (all except Universal and SQL Server). When generating C# entity classes with Entity Developer, properties may appear as non-nullable even though nullable reference types are expected. This ...
Specifying the License Key in the Devart EF Core Model
This article is for dotConnect providers with ORM support (all except Universal and SQL Server). When creating a Devart EF Core model, the license key is not required at design time. However, during execution the following error may appear: “Feature ...
Error: “Feature is not supported” (license key validation in .NET Standard)
This error occurs when Devart .NET Standard assemblies cannot validate a license key at runtime. The guidance applies to all dotConnect providers. After migrating a working .NET Framework application to .NET Core / .NET 6–9 and referencing NuGet ...
End-User Licensing and Deployment with dotConnect
Applications developed with dotConnect can be distributed to end users without additional licensing costs. This article describes the licensing rules and deployment requirements. The information applies to all dotConnect providers. End users of an ...
Updating dotConnect to a New Version
This article explains the procedure for updating dotConnect to the latest version. The instructions apply to all dotConnect providers. Update Procedure 1. Uninstall the previous version Open Settings → Apps → Installed apps → Uninstall and remove all ...
Installing Multiple Versions of dotConnect Providers on One Machine
This article describes whether multiple versions of dotConnect providers can coexist on a single system. The information applies to all dotConnect providers. All dotConnect providers rely on a shared core assembly, Devart.Data.dll. Because this ...
How to Completely Remove Previous Versions of dotConnect Providers
Conflicts may occur if older dotConnect versions remain on the system, leading to installation errors or issues in Visual Studio. This article describes how to fully remove previous versions before reinstalling. The instructions apply to all ...
Where to Apply the License Key in dotConnect Providers
License key usage in dotConnect providers varies depending on the target framework. In .NET Framework projects, licensing is managed automatically during installation, whereas .NET Core and later versions require the license key to be provided at ...
Installation vs. NuGet in dotConnect Providers
dotConnect providers can be added to a project in two ways: by installing the product or by using NuGet packages. The choice depends on the project type and the .NET version you are targeting. This article applies to all dotConnect providers. Two ...
How to Configure ODBC in Adobe ColdFusion
This guide explains how to configure ODBC (Open Database Connectivity) in Adobe ColdFusion to enable seamless connectivity between ColdFusion and various databases. While ColdFusion primarily supports JDBC, it is still possible to use ODBC through ...
Guide: Configuring ODBC Driver in Azure Data Factory
This guide walks you through the steps of setting up and using an ODBC driver in Azure Data Factory (ADF) for seamless data integration. By following this guide, you will be able to configure an ODBC driver, create a Linked Service, and define an ...
Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver
This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...
Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver
This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...
Setting up a Connection to Power BI Online Using Devart ODBC Driver
In this guide, we will walk you through the process of setting up a connection to Power BI Online using the Devart ODBC Driver. This involves creating a DSN connection, setting up an on-premises gateway, and verifying Power BI report settings. Step ...
Setting up a Connection to QuickBooks Desktop Using Devart ODBC Driver
This knowledge base article provides step-by-step instructions on how to set up a connection to QuickBooks Desktop using the Devart ODBC Driver. Following these steps will help you successfully connect to QuickBooks Desktop and retrieve your ...
ODBC Drivers: Recommendations for Working with MS Access
When connecting to external ODBC data sources in Microsoft Access, it’s important to understand the performance differences between pass-through queries and linked tables. Pass-Through Queries Pass-through queries execute on the server, returning ...
Error "Cannot load client library: <path libs>" in Products: IBDAC, UniDAC (InterBase, FireBird), ODBC (InterBase, FireBird)
Issue When working with IBDAC, UniDAC, or the Devart ODBC Driver for InterBase or Firebird, you may encounter the error: "Cannot load client library: <path libs>" This error typically indicates one of the following issues: The specified client ...
Configuring OAuth 2.0 Authentication in Salesforce
OAuth 2.0 (Open Authorization 2.0) is an open standard for access delegation, commonly used to grant third-party applications limited access to a user’s resources without exposing their credentials. It allows secure access to a resource on behalf of ...
How to Work in Power Query Using ODBC Driver
1. Connect to an ODBC Source In Power BI Desktop, go to the Home tab and click on Get Data to connect to an ODBC source. From the list of available connections, select the DSN connection that you created in the ODBC Administration tool. You can learn ...
How to Connect Using ODBC in Crystal Reports
Crystal Reports allows users to build custom reports by connecting to various data sources. To connect using an ODBC driver, follow these steps: Step 1: Create a Crystal Reports Application Launch Crystal Reports and create a new report. Select a ...
How to Set Up Devart ODBC Drivers for OAuth Authorization in Cloud Services
To connect to cloud databases like HubSpot, Zoho, or Salesforce using OAuth authorization, follow these general steps: 1. Register an Application Start by registering your application in the cloud service you're connecting to (e.g., HubSpot, Zoho, or ...
How to Troubleshoot the 'License Not Activated' Error
If you encounter a "license not activated" error: Check the license status in the driver settings. Try restarting the application or server. Reactivate the license using Devart’s License Manager. For web apps, ensure the license file is accessible to ...
Using ODBC Drivers with Power BI Online
Power BI Online supports working with ODBC drivers, but to ensure proper functionality—especially for scheduled data refresh—you need to configure the setup correctly. Make sure the Power BI Data Gateway is installed on the same computer where the ...
[Devart][ODBC][QuickBooks Desktop] Could Not Start QuickBooks
When attempting to test the connection for the Devart ODBC Driver for QuickBooks Desktop, the following error may occur: "[Devart][ODBC][QuickBooks Desktop] Could not start QuickBooks" This issue typically indicates that the connection prerequisites ...
Tableau cannot get quest tables and colums with ODBC Drivers
Tableau cannot get quest tables and colums with ODBC Drivers In Tablеau, after selecting an ODBC source, to obtain a list of tables available to the driver and work with them, use the following button: Next, load the list of tables by clicking on the ...
Troubleshooting the "Invalid Login Attempt" Error in Devart ODBC Driver for NetSuite
If you encounter the following error when connecting via the Devart ODBC Driver for NetSuite: Error: [Devart][ODBC][Netsuite] "Invalid login attempt" Make sure that Token-Based Authentication (TBA) is enabled for the integration you're using in your ...
How to Configure Devart ODBC Drivers for Optimal Performance
To ensure optimal performance when using Devart ODBC drivers, it's recommended to fine-tune several key parameters: Connection Timeout — Set an appropriate timeout to avoid long waits on unresponsive connections. Data Fetching Size — Adjust the ...
Managing Zoho API Credits with the ODBC Driver
The Devart ODBC driver for Zoho is designed to use the minimum number of API credits for operations. However, the exact number of credits consumed depends on various factors, including the type of data you're accessing. Why Does the API Consume More ...
Error 193 While Creating ODBC Connection in ODBC Administration
If you encounter Error 193 while creating an ODBC connection, it's important to note that our ODBC drivers currently do not support Windows ARM. We are actively working on expanding compatibility and will provide updates on the possibility of ...
Unable to Connect Using macOS DSN Configuration
If you’ve installed an ODBC driver on macOS but can’t proceed with setting up a DSN because the iODBC Data Source Administrator app is missing, here’s how to resolve the issue. Step 1: Install iODBC Manager To test and manage ODBC connections on ...
Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce
When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...
What SQL Syntax Can Be Used with Devart ODBC Drivers?
Devart ODBC Drivers internally rely on the SQLite engine to execute SQL queries. This means that all SQL statements executed through the driver must conform to the SQLite SQL dialect. The SQLite engine supports a wide range of SQL features including: ...
System Views Missing in SSMS When Using Devart Connector as a Linked Server
When using the Devart ODBC driver as a linked server in SQL Server Management Studio (SSMS), you might encounter a situation where the System Views section appears but contains no visible data. How to Access Metadata The necessary metadata can still ...
Next page