KB ID : 115047
Published : Aug. 8, 2017
Created : Aug. 8, 2017
Last Modified : Aug. 8, 2017

Solution

Please perform the below steps to resolve the ODBC permission issue for Vembu BDR\OffsiteDR server with PostgreSQL as Database:

  1. Open ODBC Driver- 32 bit (Control Panel\System and Security\Administrative Tools) using "Run As Administrator" option.
  2. Navigate to System DSN tab.
  3. Click on OK to the popup that received with the error "You are logged on with non-administrative privileges system dsn could not be created or modified".
  4. Click on Add.
  5. Choose the option” PostgreSQL Unicode Driver”.
  6. Enter the Data Source Name as "PostGreDBConnection".
  7. Server Address as "localhost".
  8. Provide user name as "postgres" and password as "admin" (Or the password that you have chosen during the installation of PostgreSQL).
  9. Choose the Database as "SGDatabase". The above details can be gathered from "VembuBDR_Home/conf/SGConfiguration.conf" file under "Use ODBC tag".
  10. Click on "Test" to verify the connection.
  11. Once it is successful click on OK to save the settings.

Repeat the same for ODBC 64 Bit drivers and check the result.

edit retag flag offensive close merge delete