Connect Labview to PostgreSQL

[leandrofeder]

Hello

I have a demand to integrate my system in LabVIEW with a PostgreSQL database.
The database was created by the company's IT team, and they gave me some information from the bank, such as:

Host
Port
User/Owner
Passowrd
Database

I'm trying to establish communication with the database with this information but I'm not succeeding, can you help me?

[LVNinja]

Can you share what have you done so far ? 

[leandrofeder]

Here is the VI, with the real data masked

[Martin_Henz]

connection strings can be found here 

[ooth]

What I do is create a udl file with all the connection info. Do this by going to Tools-->Create Data Link.

Then I wire a path of that file to the input on the Open Connection.vi. This way I can test the connection in the udl interface and make sure I get the "Test connection succeeded" before I go to LabVIEW. Sort of like how you test the VISA connection in MAX before opening it in LabVIEW.

[Yamaeda]

---

@ooth wrote:

What I do is create a udl file with all the connection info. Do this by going to Tools-->Create Data Link.

Then I wire a path of that file to the input on the Open Connection.vi. This way I can test the connection in the udl interface and make sure I get the "Test connection succeeded" before I go to LabVIEW. Sort of like how you test the VISA connection in MAX before opening it in LabVIEW.

---

As an addendum, the .udl is a simple text file, so you can copy the content and use as Connection string if you don't want to use the file.

[ooth]

Well I'll be. It is just a text file. At least the udl tool helps to get the connection string formatted correctly.

[Yamaeda]

---

@ooth wrote:

Well I'll be. It is just a text file. At least the udl tool helps to get the connection string formatted correctly.

---

Oh yes, that's how i use it. 🙂