Data Connectivity
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 ...
ODBC Driver for FireBird. Error:"Cannot load client library: <path libs>
The error you describe might mean that the driver didn't find the specified "Client Library" or that the client library doesn't match the bitness of your DSN. Please be informed that Devart ODBC Driver for FireBird interacts with the server through ...
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 created linked server with ODBC Drivers. "The specified DSN contains an architecture mismatch"
Please be informed that the error "The specified DSN contains an architecture mismatch" indicates that the computing of our driver and SQL Server are different. To operate as part of Linked Server, you need to install the ODBC driver on the same ...
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 ...
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
Please note that we cannot influence the behavior of MS Excel and in this case, if you do not want other users to see the password, then you should not save it in the DSN, but manually enter it every time you establish a connection.
ODBC Data Sources (64-bit) Data Source config error
Kindly note that you are getting the GDS Function not linked error because the Client Library field specifies the path to our Devart InterBase ODBC Driver library (DevartODBCInterBase.dll), not the InterBase client library (ibclient64.dll for ...
How to get specified Entity from TMappedCollection in EntityDAC
EntityDAC doesn't have a method similar to TDataSet.Locate. You can implement a similar behavior by retrieving every item from a collection, as shown in the EntityDAC demo ("Get Entities by Collections"). Another way is to find the needed element ...
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 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: ...
ODBC Driver for QuickBooks
Currently, Devart ODBC Driver for QuickBooks supports only the QuickBooks Online platform however our team is working on the possibility of implementing the compatibility with other QuickBooks products.
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 Excel
Excel can disable Add-ins on its own in case of errors, or if Add-ins take too long to complete their operations. Perhaps this is such a case. However, you can enable the Add-ins without restarting the OS. File -> Options -> Add-ins -> Manage: COM ...
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 - ...
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
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 (x86)\Devart\dotConnect\MySQL\ , GAC 2.0 ...
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 ...
Schttpwebrequest response
In order to get data returned by the server, you need to handle HttpException. To do this, please try doing the following: try Response := ScHttpWebRequest1.GetResponse; except on E:HttpException do showmessage(E.ServerMessage); end; In this case, ...
ORA-12705 error
In most cases, this error appears when NLS_LANG environment variable on your deployment server contains an invalid language, territory, or character set. To fix it please follow the instructions for the article below: ...
Cannot obtain Oracle Client information from registry.
The error you are facing says that Oracle Client is not installed or the bitness of the application doesn't match to the bitness of the client. 1.) Install Oracle Client 2.) Configure the connection to your server in the tnsnames.ora file. 3.) Make ...
Next page