Forums Home / ActiveReports / ActiveReports v7+
Posted by: bram.neirinck on 19 March 2023, 9:53 pm EST
bram.neirinck
Posted 19 March 2023, 9:53 pm EST
Hello,
I’m using the oracle provider sample (user designer) to connect to our database. I’ve been using v16.2.0 and everything works.
Now I’ve upgraded to the latest version 16.4.0 and I can’t change the connectionstring anymore.
It defaults back to : DATA SOURCE=source;Password=;User Id=user;
So the password it replace by an empty value.
I’ve tried every version and the issue starts with version v16.2.1.
Do you have any advice?
Regards,
Bram
akshay.rajput
Posted 20 March 2023, 10:21 pm EST
Hi Bram,
Thank you for bringing the issue to our attention. In order for us to better understand the issue you are facing, we kindly request that you send us a screen recording of the problem you are experiencing. If you are unable to upload the video over the public forum, I would suggest you to open a support case and attach the video with reference to this forum case so we I can get back to you over the support case. This will allow us to see the issue first-hand and determine the best course of action to resolve it.
We appreciate your cooperation and look forward to resolving the issue as quickly as possible.
bram.neirinck
Posted 21 March 2023, 1:26 am EST
Hi,
See attached the behavior. When I change the connectionstring to something it always goes to to the previous value but without a password.
It worked before v16.2.1.oracleprovider.zip
akshay.rajput
Posted 21 March 2023, 10:51 pm EST
Hi Bram,
Oracle Data Provider not available since System.Data.OracleClient is deprecated. We add the Oracle Data Provider using the CustomDataProvider approach for more information please refer to the following page of our documentation: https://www.grapecity.com/activereportsnet/docs/latest/online/add-custom-data-providers.html
It might be possible that upgrading from an older version is causing the issue. I would suggest you to modify our GitHub Designer Sample Mentioned here: FlatEndUserDesigner and add the Oracle Data Provider to it.
You may refer to the following sample application for adding Oracle Data Provider: Oracle Data Provider Sample
Based on the above approach, I have modified the FlatUIDesigner and attached it along with.
Regards,
Akshay
bram.neirinck
Posted 21 March 2023, 11:25 pm EST
Akshay,
I’m using that example and added the provider. That works until v16.2.1.
In your demo you are using v16.1.1 and that works fine.
Regards,
Bram
akshay.rajput
Posted 23 March 2023, 8:19 pm EST
Hi Bram,
I have update the sample to ActiveReports 16.4.0 and the DataSource UI is working at my end. Please test with the attached application: OracleDataProvider.zip
Please let us know if the issue persists.
Regards,
Akshay
bram.neirinck
Posted 23 March 2023, 10:41 pm EST
Akshay
When I use your example with my report then I still get the same error.
When adding a space in the datasource and pressing the check button, it clears the password.
I’ve attached my report
report.zip
akshay.rajput
Posted 28 March 2023, 3:44 pm EST
Hi Bram,
Apologies for the detail in getting back to you. I have successfully reproduced the behavior on my end and have identified that setting the password via the credentials tab does not remove the existing password. I am currently investigating this issue in more detail and will provide you with an update as soon as possible. Thank you for your patience and understanding.
Regards,
Akshay
akshay.rajput
Posted 28 March 2023, 4:13 pm EST
Hi Bram,
This seems to be an issue in the UI. I have escalated this issue to the development team and will get back to you once I have any information on the same. [AR-30548]
Regards,
Akshay
