Database connection working on windows-legacy but not working on windows

Help Studio
, ,
1

Hi All,
we are able to connect DB on Window legacy but unable to connect DB working on Window.
how to resolved this issue in window.

2

@AsadPathan2665

What error are you getting?

did you try with the latst db package only?

cheers

3

yes @Anil_G
below error is coming
Connect to database: The specified invariant name ‘System.Data.SqlClient’ wasn’t found in the list of registered .NET Data Providers.

5

@AsadPathan2665

In windows this client is not ssupported

Try Microsoft.Data.SqlClient one

Cheers

6

give a try by:
change the Provider Name in the Connect activity to Microsoft.Data.SqlClient.

7

Hi @ppr
Not working this provider name

8

then let us know the details of:

  • modellings
  • version of the UiPath.DataBase.Activities
9

Hi @ppr
Modellings- ?
Activity version - 1.7.1

10

screenshot of what was done in UiPath (related activites) and its relevant configurations (redact sensitive parts e.g. passwords…)

11

We are using database activity to connect DB.
UiPath database activity version -1.7.1

12

ok thanks, it is up to you on what you want to share with us. Depending on more details we can give more specific help. From shared info you can derive

  • Adaptions: package version / provider name
  • Adaptions / check: connection string