Data Connectivity
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"). ...
Using TMyConnection in EntityDAC
The standard way to work with the TMyConnection class in EntityDAC is through EntityDAC.DataProvider.MyDAC. However, this built-in provider does not support advanced TMyConnection features. If you require such functionality, consider creating a ...
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: Update, Insert, and Delete Records
This example demonstrates a basic flow pattern for updating, inserting, or deleting records when working with SSIS (SQL Server Integration Services). In this scenario, the destination table is aligned with the source table: The flow is: General Flow ...
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 ...
Using SSL with dotConnect for PostgreSQL from NuGet
When using dotConnect for PostgreSQL via NuGet packages, note that SSL support is not included in the NuGet assemblies by default. To enable SSL connections, you must manually add the necessary assemblies from the full Devart installation package to ...
Error: "Cannot obtain Oracle Client information from registry"
This error typically means that either: the Oracle Client is not installed, or the bitness (x86/x64) of your application does not match the installed Oracle Client. ? For 32-bit applications (x86) 1. Ensure that the "Platform target" is set to x86 ...
"Help Content Manager" Error During Installation
If you see the "Help Content Manager" error when installing dotConnect, don’t worry — this is not a critical issue. You can continue using the product normally and access our documentation online: ? Devart dotConnect for PostgreSQL Documentation How ...
Resolving Assembly Version Issues by Cleaning the Global Assembly Cache (GAC)
You might encounter assembly version conflicts if an incomplete uninstall of a previous dotConnect provider leaves an empty folder in the Global Assembly Cache (GAC). This is an uncommon occurrence. Accessing the Global Assembly Cache: The Global ...
Digital Signature with SHA256 RSA
To address potential issues related to digital signatures using SHA256 RSA, you can directly utilize the TScKey object as demonstrated in the following example: uses ...ScBridge, ScUtils; var Source, Signed: TBytes; aComment: string; Key: TScKey; ...
Handling Accented Characters in TScHttpWebResponse
The ScHttpWebRequest1.GetResponse.ReadAsString method expects the response content to be encoded in UTF-8 and decodes it accordingly. If you encounter issues with accented characters not being displayed correctly, it might indicate that the response ...
Accessing Server Response Data with TScHttpWebRequest
When working with TScHttpWebRequest, it's crucial to properly handle potential server errors to access any data returned by the server, even in error scenarios. The HttpException provides valuable information about the server's response in case of an ...
Resolving ORA-12705 Error
The ORA-12705 error, "Invalid or unknown NLS parameter value specified," typically arises when the NLS_LANG environment variable on your deployment server is configured with an invalid language, territory, or character set. This mismatch between the ...
"Cannot obtain Oracle Client information from registry" Error
The error message "Cannot obtain Oracle Client information from registry" when working with Oracle typically indicates that either the Oracle Client is not installed on your system, or there is a mismatch in the bitness between your application and ...
Accessing Inserted Records Before SubmitChanges() in LINQ to SQL
When working with LINQ to SQL and performing batch insert operations, you might need to access the properties of the newly inserted records before calling SubmitChanges(). Standard LINQ to SQL queries against the Table<T> will only reflect the data ...