Data Connectivity
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 ...
UNIDAC. Error:"Cannot load client library: <path libs>
The error you describe might mean that UniDAC didn't find the specified "Client Library" or that the client library doesn't match the bitness of your app. Please be informed that UniDAC interacts with server through client library with help of ...
IBDAC.Error:"Cannot load client library: <path libs>
This error may indicate that IBDAC cannot locate the specified Client Library or that the library's bitness does not match the application's bitness. IBDAC interacts with the server through the client library using a special API. Client libraries are ...
ODBC Driver for FireBird. Error:"Cannot load client library: <path libs>
This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for FireBird interacts with the server through the client library using a ...
ODBC Driver For InterBase. Error:"Cannot load client library: <path libs>
This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for InterBase interacts with the server through the client library using a ...
how to work in Power Query using odbс driver
Connect to an ODBC source. In the Power BI Desktop Home tab, select Get Data> to connect to an ODBC source. From the list of available connections, select the required DSN connection created in ODBC-Administration You can familiarize yourself with ...
how to connect using odbс in Crystal Reports
Connecting to an ODBC source. Create a Crystal Reports application and select a report type. Click on Create New Connection >> ODBC From the list of available connections, select the connection we need: After selecting a connector, a list of ...
How to set up Devart ODBC drivers for OAuth authorization in cloud services?
For cloud databases such as HubSpot, Zoho, or Salesforce, OAuth authorization can be configured by registering an application in the target service and using the OAuth credentials within the Devart driver settings. Detailed steps are available in the ...
How to troubleshoot 'license not activated' issues?
If you encounter a 'license not activated' error, verify the license status in the driver settings. Sometimes, restarting the application server or reactivating the license via Devart's license manager resolves the issue. For web applications, ensure ...
Can I use the odbc driver in Power BI Online?
However, I am encountering an issue with data updating in the cloud via Power BI Gateway. Despite the smooth operation in Power BI Desktop, the data does not seem to update as expected when using the cloud service. Do you have any documentation or ...
[Devart][ODBC][Quickbooks Desktop] Could not start Quickbooks
I am attempting to evaluate the Quickbooks Desktop ODBC Driver. When I set up the ODBC data source, link it to the company file and then click "Test Connection" I get the following error message: "[Devart][ODBC][Quickbooks Desktop] Could not start ...
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 ...
Error: [Devart][ODBC][Netsuite] "Invalid login attempt"
Make sure that your related integration has the TOKEN-BASED AUTHENTICATION enabled. You should check your audit trail detail in your NetSuite account, go to Setup > Users/Roles > View Login Audit Trail, check USE ADVANCED SEARCH, and be sure to add ...
How to configure Devart ODBC drivers for optimal performance?
To optimize Devart ODBC drivers, consider configuring parameters that influence the connection timeout, data fetching size, and logging level. Adjust settings based on the database you are using, especially for cloud connections like Salesforce or ...
The odbc-driver uses a large number of calls API Zoho Credits
Our driver uses the minimum possible amount of API credits for operations on Zoho data. The number of API credits consumed by each operation is determined by the Zoho API for specific tables, field types, etc. There are several reasons for the ...
error 193 while creating odbc connect in ODBC Administration
error 193 while creating odbc Please note that our ODBC Drivers do not currently support Windows ARM. We will investigate the possibility of using our products on the Windows ARM operating system.
unable to connect macOS DSN Configuration
On Mac, I installed the ODBC driver to connect . This driver is installed successfully but in this directory, the IODBC Data Source administer apk is not created. So I do not perform the next steps. lease be informed that to check the test ...
Cannot open table ‘Case’ and’ Order’ in SSMS with ODBC Driver for Salesforce:
Please also note another peculiarity when working with SQL Server Management Studio. Regular queries executed in this tool will be processed by the SQL Server's own syntax parser. After this analysis, the query actually executed by the provider may ...
what sql- syntax can be used when using ODBC Drivers?
Please be informed, that Devart ODBC Drivers uses the SQLite engine to execute SQL queries, so in order to build queries with it you can use the syntax used in SQLite: http://www.sqlite.org/lang.html
System Views Missing in SSMS When Using Devart Connector as a Linked Server
We wanted to inform you that the necessary information can be obtained by accessing the following internal views: SYS_TABLES - lists available tables and their parameters SYS_COLUMNS - lists table columns, determines to which tables they belong, ...
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 created linked server with ODBC Drivers. Error: "Data source name not found"
Please note that the error "Data source name not found" occurs because Microsoft SQL Server cannot access the driver. To resolve this issue, please ensure that the driver is installed on the same computer as the Microsoft SQL Server instance that you ...
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. ...
Help Content Manager Error
If you are getting the following error: This is not a critical error, you can ignore it and use online documentation: https://www.devart.com/dotconnect/postgresql/docs/ In order to avoid error, before installation of dotConnect press Modify ...
Assembly version is found in Global Assembly Cache (Clean GAC)
The issue can occur if gacutil left the empty folder in the \GAC_MSIL\ after uninstalling the previous version of a dotConnect provider. This is a very rare case in fact. The Global Assembly Cache can be found here: ...
Digital Signature - SHA256 RSA
In order to fix this issue you may use TScKey object directly as shown in an example: uses ...ScBridge, ScUtils ... var Source, Signed :TBytes; aComment: string; Key: TScKey; ... Key := TScKey.Create(); ...
TScHttpWebResponse (accented characters)
Method ScHttpWebRequest1.GetResponse.ReadAsString expects response to have a UTF-8 encoding, and decodes them as UTF-8. You may get response content "as-is" by using -ScHttpWebRequest1.GetResponse.ReadAsBytes ...
Next page