A bit of digging got me an "Encryption not supported" error, which led me to discover that SQL Native Client 11.0 is deprecated and technically not supported for SQL 2019.
According to https://docs.microsoft.com/en-us/sql/re ... rver-ver15, only up to SQL 2014 is supported. The current recommended client is the new ODBC client.
Anyways, it has been working for a few months, so some helpful Windows update must have broken it (There were a number applied to the remote desktop server yesterday).
Thankfully, y'all had a similar problem previously (if in reverse, I think) https://docs.jiwa.com.au/display/J7UG/C ... gon+Failed.
The solution for my problem is the same: make Crystal use the OLEDB driver instead.
This is the bit of magic code, adapted for 7.2.1 (using Plugin.Manager instead of Manager.Instance). I just put the one line into an existing 'general-purpose' plugin that the customer has.
- Code: Select all
public class ApplicationManagerPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin
{
public override object InitializeLifetimeService()
{
// returning null here will prevent the lease manager
// from deleting the Object.
return null;
}
public void Setup(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin)
{
Plugin.Manager.CrystalReportsProviderName = "SQLOLEDB";
}
}