Skip to Content
0
Jun 23, 2020 at 05:36 PM

Data Access issue with SAP for Visual Studio

231 Views

Upgraded from Visual Studio 2015 Professional and SQL 2012 to Visual Studio 2019 Community with SQL 2019. Wrote a C# application with Crystal Reports using stored procedures. Running the application reports work without issue. When I go into report design I cannot preview the report. Went into 'Set Datasource Location' to update database location. Make new connection | SQL Server Native Client | Select server name, user id, password and database no issues. When I select 'Update' I get a message Database Object Cannot be opened / accessed" then "Unknown Database Connection Error".

I am running Windows 10 Professional with all the latest updates. Nothing online I have researched address this particular issue. If I create a new report I can connect and preview the report. Tried to copy field from new report to current which did not work. I do not understand if I can connect to the database why Update datasource location is not working.