# Connect to remote database

**URL:** <https://discourse.openiap.io/t/connect-to-remote-database/295>\
**Category:** OpenRPA\
**Created:** [February 27, 2023, 9:23am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295 "2023-02-27T09:23:26Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 9:23am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/1 "2023-02-27T09:23:26Z")

</div>

Hi everybody, i need to connect to a remote database to perform various actions like insert and select during the workflow.  
If it’s possible, how can i do it?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Allan\_Zimmermann](https://discourse.openiap.io/user_avatar/discourse.openiap.io/allan_zimmermann/32/12_2.png) [@Allan\_Zimmermann](https://discourse.openiap.io/u/Allan_Zimmermann)\
**Post date:** [February 27, 2023, 9:29am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/2 "2023-02-27T09:29:21Z")

</div>

Run openrpa.msi installerer again, and select to instal MDAC ( odbc ) support  
This will add some activities to talk to any database that is supported by odbc/jdbc

---

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 9:45am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/3 "2023-02-27T09:45:26Z")

</div>

Thanks Allan!  
i have to use a connection string like this:  
jdbc:mysql://x.x.x.x:port/?user=myuser  
But filling the form with my login information and then testing the connection prompts me the following error  
 ![immagine](https://discourse.openiap.io/uploads/default/original/1X/a54f422a74b5c4a6d7a43417e44a28b184f78da9.png)  
I’m surely doing something wrong, do you have any suggestions?  
Thanks again

---

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 9:46am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/4 "2023-02-27T09:46:43Z")

</div>

The error is in Italian, it says “origin data name not found and driver not specified”

---

<div class="post-metadata">

**Author:** ![Allan\_Zimmermann](https://discourse.openiap.io/user_avatar/discourse.openiap.io/allan_zimmermann/32/12_2.png) [@Allan\_Zimmermann](https://discourse.openiap.io/u/Allan_Zimmermann)\
**Post date:** [February 27, 2023, 9:54am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/5 "2023-02-27T09:54:10Z")

</div>

Have a look here

> **[examples-files/database-examples at master · open-rpa/examples-files](https://github.com/open-rpa/examples-files/tree/master/database-examples)**
>
> master/database-examples

---

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 10:28am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/6 "2023-02-27T10:28:50Z")

</div>

Looked at your examples but i get “Unable to find the requested .NET Framework Data Provider”, which sound strange to me, since i have it installed.  
I need to use a specific version? i am still missing a piece ☹

---

<div class="post-metadata">

**Author:** ![Allan\_Zimmermann](https://discourse.openiap.io/user_avatar/discourse.openiap.io/allan_zimmermann/32/12_2.png) [@Allan\_Zimmermann](https://discourse.openiap.io/u/Allan_Zimmermann)\
**Post date:** [February 27, 2023, 10:34am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/7 "2023-02-27T10:34:18Z")

</div>

I don’t have access to an mysql server right now, so cannot test, but sounds like you have not installed the odbc drivers. For microsoft to talk to a database a odbc driver need to be present.  
There is a button to configure the connection string, do you see my sql there ? keep in mind, openrpa is 64bit so you NEED to install the 64 bit version of the odbc driver as well.

---

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 10:38am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/8 "2023-02-27T10:38:29Z")

</div>

Yes i can see your connection string. I’ll try installing odbc drivers.  
If i solve the issue i’ll post here.

Thanks again!

---

<div class="post-metadata">

**Author:** ![alessandro](https://discourse.openiap.io/letter_avatar_proxy/v4/letter/a/ac91a4/32.png) [@alessandro](https://discourse.openiap.io/u/alessandro)\
**Post date:** [February 27, 2023, 10:59am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/9 "2023-02-27T10:59:23Z")

</div>

Solved! It was just me, since i didn’t create the odbc origin from windows admin panel.  
After creation everything worked!

Thanks again!

---

<div class="post-metadata">

**Author:** ![Allan\_Zimmermann](https://discourse.openiap.io/user_avatar/discourse.openiap.io/allan_zimmermann/32/12_2.png) [@Allan\_Zimmermann](https://discourse.openiap.io/u/Allan_Zimmermann)\
**Post date:** [February 27, 2023, 11:00am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/10 "2023-02-27T11:00:49Z")

</div>

Glad you found a solution.

---

<div class="post-metadata">

**Author:** ![system](https://discourse.openiap.io/uploads/default/original/2X/a/a1ca7b164ac9a826839704d9ac82c7b5e6bcf557.png) [@system](https://discourse.openiap.io/u/system)\
**Post date:** [March 6, 2023, 11:01am UTC](https://discourse.openiap.io/t/connect-to-remote-database/295/11 "2023-03-06T11:01:37Z")

</div>

Closed on March 6, 2023, 11:01am UTC

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