# How can I access a database using a SQL query?

**URL:** <https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433>\
**Category:** Help\
**Tags:** studio, database, activities\
**Created:** [January 15, 2020, 9:51pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433 "2020-01-15T21:51:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![nedenfield](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nedenfield/32/178315_2.png) [@nedenfield](https://forum.uipath.com/u/nedenfield)\
**Post date:** [January 15, 2020, 9:51pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/1 "2020-01-15T21:51:57Z")

</div>

I can not seem to find the recommended UiPath.Database.Activities package in the Manage Packages section.

I am also not seeing the “Connect” activity in my UiPath Studio.How can I install the package?

---

<div class="post-metadata">

**Author:** ![fernando\_zuluaga](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/fernando_zuluaga/32/462699_2.png) [@fernando\_zuluaga](https://forum.uipath.com/u/fernando_zuluaga)\
**Post date:** [January 15, 2020, 9:55pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/2 "2020-01-15T21:55:36Z")

</div>

you need to connect first UiPath to database using ODBC, here are a tutorial  
[https://www.rpamantra.com/connect-to-sql-database-using-uipath/](https://www.rpamantra.com/connect-to-sql-database-using-uipath/)

---

<div class="post-metadata">

**Author:** ![nedenfield](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nedenfield/32/178315_2.png) [@nedenfield](https://forum.uipath.com/u/nedenfield)\
**Post date:** [January 15, 2020, 9:57pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/3 "2020-01-15T21:57:43Z")

</div>

Fernando, the “Connect” activity does not appear on my screen when I search for it, how do I get it to appear?

![image](https://global.discourse-cdn.com/uipath/original/3X/2/e/2eca3202dac2395b98fec3cad3c14faa00aa79c6.png)

---

<div class="post-metadata">

**Author:** ![fernando\_zuluaga](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/fernando_zuluaga/32/462699_2.png) [@fernando\_zuluaga](https://forum.uipath.com/u/fernando_zuluaga)\
**Post date:** [January 15, 2020, 9:59pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/4 "2020-01-15T21:59:02Z")

</div>

are you sure you are searching here?

 ![image](https://global.discourse-cdn.com/uipath/original/3X/a/9/a9c483f66058979931d59d9f56e55eaece3cc195.png)

---

<div class="post-metadata">

**Author:** ![nedenfield](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nedenfield/32/178315_2.png) [@nedenfield](https://forum.uipath.com/u/nedenfield)\
**Post date:** [January 15, 2020, 9:59pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/5 "2020-01-15T21:59:53Z")

</div>

Yes, I am.

 ![image](https://global.discourse-cdn.com/uipath/original/3X/f/c/fce57746bfcfe7db3d59a79f033d3efd9d5404a0.png)

---

<div class="post-metadata">

**Author:** ![fernando\_zuluaga](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/fernando_zuluaga/32/462699_2.png) [@fernando\_zuluaga](https://forum.uipath.com/u/fernando_zuluaga)\
**Post date:** [January 15, 2020, 10:16pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/6 "2020-01-15T22:16:09Z")

</div>

then i think you have to install it manually, but find again in [nuget.org](http://nuget.org)

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [January 15, 2020, 10:18pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/7 "2020-01-15T22:18:56Z")

</div>

Hi @nedenfield

Enable the below check box like below

 ![image](https://global.discourse-cdn.com/uipath/original/3X/c/b/cb03c79892daefdd10471722c07c72126c6001d5.png)

Now you can get the package …

 ![image](https://global.discourse-cdn.com/uipath/original/3X/9/5/9569918a1ae4e6ea1052996d4247fddca55a7755.png)

Here is the sample for Sql server database

> [@Insert SQL with variable / parameter giving error in ExecuteNonQuery activity](https://forum.uipath.com/t/insert-sql-with-variable-parameter-giving-error-in-executenonquery-activity/101739/8):
>
> Hi @ramawat, I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table script and your insert query as a zip file. May be it helps to do the analysis. But any way, Here I have attached xaml and table for your reference. [SqlServer.zip](https://global.discourse-cdn.com/uipath/original/3X/c/8/c87b8b0ed32608dfd357ae7145ae4b15257a6fd7.zip) (2.7 KB) Regards Balamurugan.S

Regards  
Balamurugan.S

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [January 21, 2020, 3:42pm UTC](https://forum.uipath.com/t/how-can-i-access-a-database-using-a-sql-query/185433/8 "2020-01-21T15:42:05Z")

</div>

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