Database Connection Error - DGDB1001
The error DGDB1001 occurs during login to the Vembu BDR or Vembu OffsiteDR web console due to an incorrect installation of PostgreSQL ODBC drivers. This issue is commonly observed after a fresh installation or an upgrade from an older version to a new version.
To resolve the DGDB1001 error, follow the steps below:
1. Download the PostgreSQL ODBC drivers version 9.6.1 from the links provided:
- Download 32-bit ODBC Driver
- Download 64-bit ODBC Driver
2. Install both the 32-bit and 64-bit ODBC drivers.
3. Open the 'ODBC Data Sources' by searching in the start menu.
4. In the 'ODBC Data Sources' window, navigate to the SystemDSN tab.
5. Select 'PostGreDBConnection' and click 'Configure.'
6. Verify the following details:
- DataSource: PostGreDBConnection
- Database: SGDatabase
- Server: localhost
- Username: postgres
- Port: 32010 (or the port specified during installation)
- Password: admin (type 'admin' in the provided field)
7. After confirming the parameters, click 'Test.' If the test is successful, the issue is resolved.