Only 100% managed code architecture for connectivity to Oracle, DB2, SQL Server, and Sybase using ADO.NET. With the 4.3.0 release, we are supporting several new features.
In case of Silent Installation for Visual Studio 2017, service pack 3 is required for a successful installation.
Accessing help files
To access product help, you must use the Internet Explorer browser. You will also need to enable ActiveX controls.
Entity Framework Support
The DataDirect DB2 Entity Framework data provider does not support the following Entity Framework feature:
Configurable Migration History - For a Code First model, when you try to customize a migration history table, you may face an issue While performing multi-level scaffolding. The Provider does not throw an error message in this case; Progress recommends that you do not use this EF6 feature, while working with DB2.
When you use the MapToStoredProcedure feature in an application using Code first Migrations, trying to execute “update-database” to update your model changes in the database throws the error, "Alter Procedure operation is not supported with DB2 UDB V6R1 for i." This issue occurs only on DB2 UDB V6R1 for i, and will work fine on higher versions.
The DataDirect DB2 Entity Framework data provider has the following limitation:
Code First Mapping to Insert/Update/Delete Stored Procedures - For your Code First model's mapped stored procedures, if the newly created mapped procedure names have an overload in the database, during migration, you may face issues while dropping the procedure. To avoid this issue, ensure that you do not have any StoredProcedures with the same name as the Procedures created in the MappedToStoredProcedure feature, before using code first migrations. To resolve this issue, you can manually drop these procedures using full signature of the procedure in the DROP PROCEDURE query.
An issue you may face during migration (while adding or removing columns in the entity mapped to procedures) is that the updated definitions may create new procedures instead of replacing the existing ones. To resolve this issue, you can remove the stored Procedures which are not in use any more by manually dropping these procedures using full signature of the procedure in the DROP PROCEDURE query.
The DataDirect Oracle Entity Framework data provider has the following limitation:
Oracle Advanced Security feature is only available for applications that are made for .NET Framework 4.0 or a higher version. To use these features, applications should refer to DDTek.Oracle.dll built within .NET Framework 4.0 present in the net40 directory under the installation directory.
If you are using Entity Framework or DbProviderFactory to create a connection with .NET Framework 4.0 or a higher version, you do not have to perform any additional steps to use Oracle Advanced Security. Please read the user guide for more details.
The DataDirect Sybase Entity Framework data provider does not support the following Entity Framework features:
Third Party Issues
While using DPE(Deployment of reports) in Visual studio 2015, the SSDT Tools version should be specifically this version - 14.0.61707.300. This version of SSDT has some issue fixes by Microsoft. If you do not use this specific version, you get the following error during deployment: "Key is not found in Dictionary."
Previously, Oracle was using non FIPS-compliant protocol for connection to Oracle server version before 184.108.40.206. This was causing all ADO.NET drivers including DataDirect and Oracle Managed ADO.NET driver to fail to connect when FIPS is enabled on client machine.
Oracle fixed this in their 220.127.116.11 version of managed ADO.NET driver implementation.
If you are building your application with EntityFramework 6.0.0, you may face the issues defined below:
To resolve this issue, we recommend you build your application with EntityFramework 6.0.2.
Logging Application Block Configuration
For the Logging Application Block to function correctly, you must perform one of the following actions:
You must be a system administrator or have update privileges for the Registry key [HKEY_LOCAL_MACHINE]. These privileges are required to update the Registry with the new data providers being installed. See your system administrator if you are unsure.
You must run the Setup program from the machine on which you are installing the product. You cannot run the Setup program from a network location to install the product on your local machine.
Installing on a Machine With Earlier Versions of the Data Providers
DataDirect Connect for ADO.NET 4.3 can exist on the same machine with earlier released versions of DataDirect Connect for ADO.NET and DataDirect Connect for .NET (GA version or with any of the patches or service packs), but cannot be installed in the same directory.
Using Distributed Transactions
The DataDirect data providers support distributed transactions through the Microsoft Distributed Transaction Coordinator (MS DTC).
Connecting to a DB2 Database
Inadequate permission to create packages on the database server. Packages must be created once on each DB2 server that the DataDirect Connect for ADO.NET DB2 provider will connect to. The provider detected that the packages do not exist on this server and tried to create them, but could not due to the current user not having BINDADD permissions on the DB2 server. Contact the DB2 administrator.
Bulk Operations with Sybase
A Sybase bulk bug prevents default values from being inserted into the destination table. This means that in bulk operations, null values are always preserved.
Visual Studio 2015 / Visual Studio 2017 Issues
Installing Visual Studio After Installing the DataDirect Connect for ADO.NET Data Providers
If you install the DataDirect Connect for ADO.NET data providers on a machine that does not have Visual Studio installed, and then install Visual Studio, you must use the Administration Tool in the DataDirect Connect for ADO.NET 4.3 program group, and select the Visual Studio Integration tab.