ODBC Driver manager error on connecting to database

[joscares (Joshua Oscares)]

What driver do I need to install to make this work? I tried 2 different odbc driver and seems like it is not the right driver

[Gokul_Jayakumar (Gokul Jai)]

Hello @joscares , Did you add the Sql drive in ODBC?

[Gokul001 (Gokul Balaji)]

Hi @joscares

Check out the Tutorial for more info

Integrating with ODBC to PostgreSQL

Hello Guys, I would like to present this tutorial who are looking for integrating ODBC to PostgreSQL Following steps are required Download step for PostgreSQL Initial Step to download PostgreSQL app on our machine. Go to Postgre website URL: Download PostgreSQL Then Click download, the Version 13.6 in column of Windows x86-64 [image] Then follow the installation procedure at postgre website: Install PostgreSQL During set up it will ask for a password, in which enter the password “ro…

Regards
Gokul

[joscares (Joshua Oscares)]

I dont have postgresql on that window do i need to download it?

[Gokul_Jayakumar (Gokul Jai)]

@joscares , Yes, anyone sql driver need to access data base.

[joscares (Joshua Oscares)]

okay doing this guide i’ll let you know the result tnx!

[Gokul001 (Gokul Balaji)]

Hi @joscares

The above tutorial contains Download the PostgreSQL and Configure with ODBC server.

This below tutorial is to configure with Uipath

Integrating PostgreSQL With Uipath

Hello Guys, I would like to present this tutorial who are looking for integrating PostgreSQL With Uipath Following steps are required Open Uipath Studio, and create new project From manage packages, search Database in All Packages and Download Uipath Database Activities Pack [image] Create new activity and search for connect to data base and drag drop the activity. [image] Then click configure connection button [image] Edit connection setting will open, then click connection wizard C…

Regards
Gokul

[Akash_Khobare (Akash Suresh Khobare)]

Hello @joscares

1. You first download ODBC 32-bit and install on your computer.
2. Once installed, open ODBC Data Source Administrator (32-bit).
3. Click on Add and select MySQL ODBC 8.0 ANSI Driver and then Finish.
4. You shall land over to connection parameters. Enter desired Data Source name.
5. After entering server parameters (in my case Wampserver) test the connection.
6. If the connection is successful, you can use this into UiPath through connect acitivity.
7. In the configure connection, you need to select Connection Wizard and then > ODBC.
8. You need to choose ‘Microsoft ODBC Data source’ from the drop down menu.
9. Finally pick up your Data source name into Data source specification.
10. Test the connection for successful and you are done with it. Cool…

Let me know if you are facing any issues into the connection.

Thank you.

[joscares (Joshua Oscares)]

Im done with the installation but I cant find this

here is mine

version installed

[Gokul001 (Gokul Balaji)]

Hi @joscares

have you done the following steps

Installation step for PostgreSQL driver

1. Install PostgreSQL driver (32-bit) click this link.
2. Then click Download>msi> psqlodbc_13_02_0000-x86.zip . Note: Don’t Install psqlodbc_13_02_0000-x64.zip, because it does not work for me.
3. Then unzip the folder and start installing “psqlodbc_x86”.
4. Click Next, then finish the setup.

Regards
Gokul

[joscares (Joshua Oscares)]

Okay, got it my next issue is this

I can’t find the right option

Here is my screenshot

[joscares (Joshua Oscares)]

Okay, seems like i set it up correctly how can I connect now to our own database? not using test environment of postgresql

[Gokul001 (Gokul Balaji)]

Hi @joscares

You have to update the parameter in this window again

Regards
Gokul

[joscares (Joshua Oscares)]

yeah tried that and this is the error i received

[Gokul001 (Gokul Balaji)]

Check the Server in the ODBC Driver @joscares

[joscares (Joshua Oscares)]

You mean this?

[Gokul001 (Gokul Balaji)]

HI @joscares

In the Server → Localhost and check it.

Regards
Gokul

[joscares (Joshua Oscares)]

Sorry where can i find the server → localhost