Joins not working
 
Notifications
Clear all

Joins not working

13 Posts
2 Users
0 Likes
140 Views
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago

Hi Oladayo, great, thanks for the update. 

 

Thanks

 dotnet Report Team

Reply
Oladayo Oduntan
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 1 month ago

Hello Razi,

 

Please see this SSL error below on publish to a demo site

image
image

 

 

Regards,

Oladayo Oduntan

 

Reply
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago
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. 
 
However, I would strongly encourage to resolve by updating the server first as it would enhance security on your server as well. Another thing is if you decide to host dotnetreport on prem, and we send you the service to setup on IIS, it might have the same problem. 
 
Let me know if you are able to resolve this or not. 
 
Thanks!
dotnet Report Team
Reply
Page 3 / 3
Share: