Database connect activity does not open wizard

Feedback Activities
, , ,
1

My system os is windows 8,so I installed sqlserver2017 and i am trying to connect my studio with database and i am facing an issue that is when i am clicking on connection wizard in connect activity i am unable to get the connection wizard any one please help me

thanks in advance
connect activity

sql
sql1318Ă—206 23 KB

3

Hi @srujana13a5

Try Restarting the studio and check once!

Regards

4

@srujana13a5

Welcome to forums

Can you restart the workflow and try again?

Thanks

5

@srujana13a5

Also, let us know if you are facing any error?

Thanks

6

ok i will try

thanks

7

Hi @srujana13a5

If restart is not helped, try to update dependent package. (UiPath.DataBase.Activities)

Thank you.

1 Like
9

Any fix on this ? I’m facing the same issue and restart is not helping.

1 Like
10

Hi @Lauri_Lemmetty

Could you please share the version of your Database activity package and your Studio version?

11

my database activity is 1.5 and studio is 2021.10.4 . Found out that the official uipath.database.activities is not working anymore. for some reason.

I installed the nuget.org odp.oracle.dataaccess.x86 and switched the odbc to oracle and then it works.

12

We had some issues with this package as not all the dependencies were uploaded properly to the official feed.

Can you please try again using a new project? Just Add Database activities and please share a screenshot of the project panel (with all dependencies expanded)

14

Hello

I have the same problem. I can’t click Connection Wizard (I click it but nothing happened). I make new project and install only UiPath.Database.Activities packege the problem is still there

Connection Wizard button
Capture1

My Packages

Capture2
Capture21307Ă—449 62.6 KB

1 Like
15

Hi @Denislav_Vladimirov

Just to confirm - is the window stuck completely, or can you still navigate to the element by using the TAB and SHIFT+TAB and SPACEBAR to navigate between the UI elements?
tabshifttab

Also, I’ve kind of reproduced this bug by switching to another application with both of those windows open:
image

When I then came back to Studio, I could no longer click on the buttons and the second window was gone:
image

However, when I did ALT+TAB, I found the lost window and was able to bring it to focus, close it and then the first one worked just fine:
image

1 Like
16

Hello Maciej,

I am facing the same issue of connection wizard not opening when I click on it. I tried alt + tab and moving to a different application and coming back to it. I have a Windows 10 machine and UIPath 2020.10.6 Enterprise license. I am trying to get an Oracle connection going.

Regards

Dhawal

17

I know the struggle, because I’ve encountered it recently as well.

It often takes a lot of tries to fish out the background window, often via a combination of minimizing all windows and then bringing studio to the foreground.

We will have a look and see how this can be improved.

18

I am having the same issue and it is not a hidden window. I have deleted UiPath.Database.Activities, restarted, etc. It is causing an error as well: Connect to database: Failed to load library (ErrorCode: 126). So, I think they are related. If I use another user id on this machine, it works. I noticed there were a lot of dependencies on the Package such as Microsoft.Data.SqlClient.SNI.runtime which were prompted to install. I suspect that the install of Microsoft.Data.SqlClient.SNI.runtime is where the issue lies (it is an older library). How do I get rid of that install so I can start again?

19

Some more clues. 2 user ids, same machine. One user can see the DB Connection Wizard (User-Works), other cannot (User-Fail). If User-Works opens User-Fail’s project, the connection wizard works. If User-Fail creates a new project, the connection wizard fails. So, it appears that the DB connection is tied to the user profile. Perhaps in the .nuget libraries?

20

This a a decent clue. The .nuget folder resides in the machine user folder.

Could you try renaming the .nuget folder and then let Studio reinstall all the dependencies?

1 Like
21

I will try and test this when time permits. Not sure if I can recreate but we have this thread in case it reoccurs. If it crops up again, this thread should lead someone to something they can test.

1 Like
22

This did in fact work for me.
I installed 1.7.1 Database Activities (after recently upgrading from Windows10 to Windows11), and was unable to open the Wizard and receiving “Connect to database: Failed to load library (ErrorCode: 126)” after pasting in connection string.
I renamed .nuget folder and reopened UiPath, fixed dependencies, and now the Wizard is opening and I moved past the “Connect to database: Failed to load library (ErrorCode: 126)” error.
Thank you

2 Likes