For the first time to connect to the Informix database, you will need to install the corresponding .NET Core data provider to the development PC.
When you select Informix from the Provider list in the Database Configuration dialog box, you will be prompted to manually download and install the provider, or have PowerBuilder automatically download and install it for you.
-
Select the first option "Install the driver from www.nuget.org" if you want to have PowerBuilder automatically download and install the driver, and if you agree with the license agreement. The driver will be automatically downloaded to your local path (%USERPROFILE%\.netdbdrives).
-
Select the option "The driver already exists locally" and then specify the location of the driver if you have manually downloaded the driver to your computer.
It must be the .NET Core data provider (Net.IBM.Data.DB2 8.0.0.300) downloaded from www.nuget.org, otherwise installation will fail.
Note:
1) Informix and DB2 use the same data provider (Net.IBM.Data.DB2 8.0.0.300).
2) The .NET Core data provider for Informix (Net.IBM.Data.DB2 8.0.0.300) requires the Visual C++ Redistributable Packages for Visual Studio 2013 to run. If the Visual C++ Redistributable Packages for Visual Studio 2013 is not installed, you will be prompted when creating the database cache in the PowerBuilder IDE.
To resolve this error, you can download and install Visual C++ Redistributable Packages for Visual Studio 2013 from https://www.microsoft.com/en-us/download/confirmation.aspx?id=40784.
