How to change crystal report data provider from SQLOLEDB to SQLNCLI11 in vb.net
Currently, I am using oledb connection to print crystal report from asp.net application.
But i want to change OLEDB connection to sql native client 11.0 dynamically because i have around 250 reports to change.
i am using below code to set database connectivity
For Each CrTable In .Database.Tables
crtableLogoninfo = CrTable.LogOnInfo
With crtableLogoninfo.ConnectionInfo
.ServerName = strServer
.DatabaseName = strDatabase
.UserID = strUserId
.Password = strPassword
End With
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next