Connecting to Database

Help Studio
, ,
1

Hello!

I am trying to connect to an oracle database with connect to database activity (Database.Activites package) but I get this error when I try to type “System.Data.OracleClient” to Provider Name:
The specified invariant name ‘System.Data.OracleClient’ wasn’t found in the list of registered .NET Data Providers.
I was trying to copy one of my older robot’s activity, but seems like it was changed/updated so it doesn’t work anymore.
How can I resolve this issue?

Thanks in advance

2

Hi @lrinczaron

I think that you are missing the provider name in the connection activity, please search your correct provider and put then in the property as string
image

Regards

1 Like
3

Hi @lrinczaron

I think this is because OracleClient was deprecated in .NET Framework 4.0 and is no longer included in .NET Core.

Can you try Installing the Oracle.ManagedDataAccess NuGet package in your UiPath project, set the provider name to “Oracle.ManagedDataAccess.Client” & build a connection string in this syntax:

Data Source=ORCL;User Id=myUsername;Password=myPassword;

Replace ORCL with your database name, and use your Oracle creds.

Hope this helps,
Best Regards.

2 Likes
4

Yes, i do that and the provider name should be correct according to this site i still get the error

5

When i try to run my robot i get the error that the package is not used, so i can’t run it