If I create a new document and add a new SQL data source, I can connect and refresh the data ok.
If I save the document locally and keep it open I can refresh and edit the data source ok.
If I restart Lumira and open the document and try to edit the data source I get the driver error:MS SQL SERVER 2014:Unable to connect.Check your data access driverSQL .
If I create a new document and select a previously used connection from the list then I have to re-enter all of the details apart from username. When I select 'Create' the application hangs on 'Connecting...
' If using a previous connection I notice that all of the fields in the advanced options are empty. If I create a new connection they are populated. If I manually enter all of the Advanced Parameters so that they match the values in a new connection I can successfully connect and refresh.
It appears the previously used connection details are not completely saved. Just wondering if this might also be the cause of the initial error when trying to refresh the data set? They get saved incomplete in the document?
Please has anyone had the same issue?