In this case, the issue may be due to the improper installation of the ODBC driver while installing PostgreSQL. To check this,
1. Go to Start and Search for ‘ODBC Data Sources’ and open it.
2. Select the SystemDSN tab and click on PostGreDBConnection.
3. Now select configure and check for the following:
- DataSource: PostGreDBConnection
- Database: SGDatabase
- Server: localhost
- Username: postgres
- Port: 32010 (or the port specified during installation)
- Password: admin (type admin in the tab given)
4. After checking for all the above parameters, click Test. If the result is a success, then the issue is rectified.
5. If the result is shown as failed, then go to "C:/Program Files/Vembu/VembuBDR/conf” and open SGConfiguration.conf in any text editor. Search for ODBC and verify with the Database name, username, and password as it was mentioned in ODBC Datasource connection.
6. If the SGConfiguration.conf file is edited and saved, a restart of the BDRSuite service from services.msc is required.
7. If the datasource name is not listed, then re-installation of Server is required (this is due to the intermediate failure of PostgreSQL installation in rare cases).