Data Connectivity
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 ...
Batch processing issue (LINQ to SQL)
In order to access inserted records before calling SubmitChanges() please use the following code below: public static List<T> WhereOrInserted<T>(this Table<T> table, Expression<Func<T, bool>> predicate) where T : class { var result = ...