I am using Visual Studio 2019 Community with Crystal Reports SP27, CRforVS13SP27_0-10010309 and CR13SP27MSI64_0-10010309. The data for the report is pulled from a SQL 2019 server using a stored procedure. I have added a new field to the stored procedure so I now need to update the report. After going into Set Datasource Location I select OLE DB (ADO) and choose SQL Native Server 11.0. In connection information once I enter the server, user id and password I can select my database without any issue. From there I can get a list of my stored procedure and choose which one I used. After selecting the stored procedure I am able to select Update which brings up the enter parameter box. Once I do that an error message pops up "Data Object cannot be opened/accessed" followed by "Unknown Database Connector Error" preventing from completing the update.
If I create a new report I am able to connect to the database and bring in data to the report. Because I can access data in a new report this issue is only with the set datasource process. I cannot find anything online to help resolve this issue. My report is very complex and I'd rather not have to recreate it. Also, I'd like to resolve this for future updates.
Thanks