Studio does not recognize the ProviderName value in the Connection with database

Help Studio
, , , , ,
1

I have built a xaml (ConnectionDataBase) in Studio that connection with data base.
When I run on Studio, it works perfectly. Connection with database working fine and geting the data without any problem.

However when I invoke this xaml to Freamwork it does not work.

Studio does not recognize the ProviderName value in the Connection action and shows an error:
Connect (HD-Oracle): Unable to find the requested .Net Framework Data Provider. It may not be installed.

My provider that runs on a single xaml file (ConnectionDataBase) is:
“Oracle.ManagedDataAccess.Client” (Client Oracle ver19 32 bit)

2

Hi @Marcin_Grzelak,

Do you have a screenshot of the error or logs with the error inside of it that you can share?

It sounds like you have a single xaml file that works fine, but when you place it into the Framework (is this the ReFramework?) - it is not working anymore. Is the ProviderName a variable? Have you validated that the value is correct when the database connection activity is reached, since this xaml is invoked from another file?

Thanks

3

Hi, thanks for the message.
Connection to the base is ok for a single xaml file (as below)

image
image528×667 25.3 KB

Error message after starting the framework
“Connect (HD-Oracle): Unable to find the requested .Net Framework Data Provider. It may not be installed.”

ProviderName is not a variable.

When editing the sequence concening connecting to the database from the framework, I get such screens for the Connection Wizard - completely different and I cannot choose Data Provider 'Oracle.ManagredDataAccess

image
image1017×982 37.8 KB

4

Hi @Marcin_Grzelak,

What are the versions of the dependencies that are you are using in each project?

Thanks

5

I don’t understand and what dependencies are you asking

6

Hi @Marcin_Grzelak,

Can you provide screenshots like this from each project, write out the names & versions of the dependencies used, or share the project.json for each project please?
image

Thanks

7

Hi Kristopher, thanks a lot for answer.

for a project that works:
image

for a project that doesn’t work:
image

8

Hi @Marcin_Grzelak,

Can you try adding the UiPath.Database.Activities v1.5.0 to your project that is not working and see if you can add the Connect activity that is associated with it?
image
I am wondering if there are different Connect activities with all of those Database dependencies mixed into your project.

Thanks

9

I found this library, I uploaded it and it worked,
thank you very much for help

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.