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
13

Hi Team,

i am facing same issue. Trying to use connect activity it is working in Windows Legacy but not in Windows.

This is happening due to The drivers i am using available for windows 32 version (DB2 wire protocol) but not available for windows 64 version.

is there any way to use Win 32 drivers in Windows version of UiPath ???

Thanks in advance.
Ratndeep Bolegave

14

Issues has been resolved for me: Windows platform works on Windows 64 bit but Windows Legacy works on 32 bit.

So open winsql 64 bit and then go to ODBC manager add the connection there as well and then try to connect in UiPath.

If you are not able to add the same connection in win 64 bit, then check the drivers required available or not otherwise you will need to install them first.

1 Like