Data Connectivity
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 ...
Error when creating a Linked Server with ODBC Drivers: "The specified DSN contains an architecture mismatch"
The error "The specified DSN contains an architecture mismatch" occurs due to a difference in architecture between the ODBC driver and SQL Server. To ensure proper operation of the Linked Server, the ODBC driver must be installed on the same machine ...
Error When Creating a Linked Server with ODBC Driver: "Data source name not found"
The error "Data source name not found" typically indicates that Microsoft SQL Server is unable to locate or access the specified ODBC data source. To resolve this issue, make sure that: The ODBC driver is correctly installed on the same machine where ...
Error opening table in linked server with Objects Explorer:
contains nocolumns that can be selected or the current user does not havepermissions on that object. Reply The message "contains no columns that can be selectedor the current user does not have permissions on that object" indicatesthat the query to ...
PgDAC activation after installation of trial version
To activate your PgDAC product after purchasing a license, no additional activation steps are required. However, if you previously installed a trial version of the DAC product, you need to follow these steps: Uninstall the Trial Version: Use the ...
Password visible in Connection string ODBC PostgreSQL
When connecting to a PostgreSQL database using ODBC, you may encounter a situation where the password is visible in the connection string in Microsoft Excel. Unfortunately, we do not have the ability to alter how Excel handles or displays this ...
ODBC Data Sources (64-bit) Data Source config error
If you are encountering the "GDS Function not linked" error, this is because the Client Library field currently points to our Devart InterBase ODBC Driver library (DevartODBCInterBase.dll) instead of the InterBase client library (ibclient64.dll for ...
How to get specified Entity from TMappedCollection in EntityDAC
EntityDAC does not provide a method equivalent to TDataSet.Locate. However, you can achieve similar functionality by iterating through a collection to retrieve the desired item, as demonstrated in the EntityDAC demo ("Get Entities by Collections"). ...
TMyConnection in EntityDac
Work with the TMyConnection class is done by calling EntityDAC.DataProvider.MyDAC. This provider does not provide the ability to use the TMyConnection features you are interested in. A possible solution is to create your own provider. Implementation ...
Assembly version is found in Global Assembly Cache
The issue can occur if gacutil left an empty folder in the \GAC_MSIL\ after uninstalling a previous version of a dotConnect provider. This is a very rare case in fact. The Global Assembly Cache can be found here: ...
SSIS Flow pattern
Here is an example pattern of update, insert or delete records. In that example destination table aligned with source table. The flow is: 1.) The source and destination tables should be ordered by the corresponding queries in the Source ...
Devart tab disappears in Microsoft Excel
Microsoft Excel may disable Add-ins automatically if errors occur or if they take too long to finish their operations. However, you can re-enable the Add-ins without needing to restart your operating system. For this, follow the steps below: Open ...
BufferSize
In order to increase performance, you can try an undocumented parameter. In the following Windows registry key: "HKEY_CURRENT_USER\Software\Devart\Excel Add-ins\Options\Import" create new parameter: New->DWORD (32-bit) Value. Name - "BufferSize". ...
dotConnect for Oracle distribution
dotConnect for Oracle is distributed in two ways: - As the installer that provides assemblies for Full .NET Framework, documentation, samples, and all the necessary files. - As NuGet packages with .NET Standard compatible assemblies for .NET Core. ...
Two sets of assemblies
dotConnect for MySQL The current implementation of dotConnect for MySQL includes two sets of assemblies: 1) the .NET Framework Devart.* assemblies which are shipped with installation: * assemblies are created in C:\Program Files ...
PostgreSQL SSL NuGets
The SSL connection is implemented in the assemblies shipped with installation, but not in NuGet packages. So, you should add to the project these assemblies: There is ConnectionString Property related to SSL: SSL CA Cert The ...
The error "Cannot obtain Oracle Client information from registry"
The error "Cannot obtain Oracle Client information from registry" means that you don’t have Oracle client installed or the bitness of your application doesn't match the bitness of your Oracle Client. ...
Next page