I have a .net core site running successfully locally using the
.NET Core 3.1/Entity Framework nuget packages. I next want to publish this site to a server (within our network, not cloud) which so far I have not been successful. The site itself is functional, however any communication via the connector fails. I feil like I've read all the articles provided (multiple times), but I haven't had any luck trying different things from that information. There is a lot of mixed info from the articles (nuget vs manual download nuget, install db2 connect vs nothing else required, etc., set PATH variable vs only needing to in linux) making it hard to know what is correct for the version I am using (latest, 3.1.0.200). I have to be missing something as I continue to get the following error:
2020-08-06T13:32:24.8236361-04:00 800003a4-0001-ff00-b63f-84710c7967bb [ERR] An exception occurred while iterating over the results of a query for context type '"Reporting.Models.IbmIDbContext"'."
""IBM.Data.DB2.Core.DB2Exception (0x80004005): ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 8036 Thread 8 AppDomain: Name:Reporting
There are no context policies. Function: AESEncryptADONET (Encryption Info)
This seems similar to this FAQ item:
> https://community.ibm.com/community/user/hybriddatamanagement/blogs/michelle-betbadal1/2020/04/29/frequently-asked-questions-about-ibm-db-net-core-p?CommunityKey=f2e5dc34-896d-4e8e-9678-724907c4b9f5&tab=recentcommunityblogsdashboard
Where it says:
> The .NET driver is unable to find the compatible GSKit. Set the Path(on Windows) or LD_LIBRARY_PATH(on Linux) to the <Package_Install_location>/<package-name>/<version>/build/clidriver/lib directory of your environment. Remember, this may affect other applications.
I've set the PATH env variable pointing to the bin directory (as well as many other attempted directories to just try stuff), but I just continue getting this error. Can anyone shed light on the full requirements based on the latest 3.1.0.200 version of the IBM DB2 Connector?
Thank you.
Shaun
------------------------------
Shaun Steckley
------------------------------
#DataManagementGlobal#DataServerDrivers