Joins not working

Hi Oladayo, great, thanks for the update. 

 

Thanks

 dotnet Report Team

Hi Oladayo, thanks for sending the details. 

 

So this is basically an issue with the version of SQL or OLEDB provider installed on the server you have pushed out to. You would basically have to install/update to a newer version of Microsoft OLE DB. Please see the link below to download: 

 

Can you also please send me the following information:

Windows Server OS Version? 

MS SQL Server version?

Are all latest Windows updates installed on the server?

 

 

Please see the following link on how to resolve it: 

This is helpful as well:

 

If you are not able to resolve this or can't make changes on the server, we can also try and resolve this in code as a last resort, by switching all instances of OleDB provider to Sql. You would have to change OleDbConnection, OleDbCommand, OleDbDataAdapter to SqlConnection, SqlCommand, SqlDataAdapter in ReportController. It might not give you the TLS related error or it might give you the same error again, I'm not sure as it's a .NET framework level issue. 

 

 

 

dotnet Report Team