When we are creating the DSN for ODBC connection to connect the Postgresql Database first time we need to check that psqlodbc driver install in our system or not. Without this driver we can’t create the DSN.
First we need to install the
Driver. Below is the official website to download the driver.
https://www.postgresql.org/ftp/odbc/versions/msi/
After Download we need to install
this driver.
Let’s create the DSN
Open the ODBC data Source
In User DSN click on the Add button.
We need to select Postgresql Unicode data Source. Click on Finish button.
In this Window we need to provide the all required information.
Click on the Test button to validate the connection.
Click ok. Save this window.
DSN is created successfully.
