How to set up the PostgreSQL ODBC driver 'hackintosh'

Go down

How to set up the PostgreSQL ODBC driver 'hackintosh'

Post by Ian025 on 2016-05-20, 11:15

The Data inventory is made up of the parts. The actual information is stored in a PostgreSQL database hosted in Queensland. The user interface is a Microsoft Access file that links to PostgreSQL and presents the information in a usable way. In the middle there is an adapter which is necessary to enable Access to talk to PostgreSQL. This is about the adapter, a PostgreSQL ODBC driver.

To access the database (including configuring 'the driver below) you need to have PuTTY running. If you don't have PuTTY running see connection-to-the-data-inventory-ssh-tunneling before attempting the secon half of this guide.

To install the Postgresql ODBC driver

  • Go to the PostgreSQL download page
  • Download the latest x86 version at the very bottom of the page. Click on the last link with 'x86' in the file name.

  • Find the downloaded file
  • Extract the installer from the Zip archive by right clicking on its icon and selecting 'Extract All…'

    By default the extract directory will be in the same location as the Zip archive.

  • Click ‘Extract’.
  • Run the Installer in the extracted directory by double clicking the ‘psqlodbc_x86.msi’ file.

  • Install the software with the default settings

To configure the Postgresql ODBC driver
Remember to have PuTTY running for this section. connection-to-the-data-inventory-ssh-tunneling

  • Open the ODBC data sources control pannel

    On Windows 7 you will need to run the control panel manually
    Press the ‘Windows key’ + ‘r’
    Type in ‘C:\Windows\SysWOW64\odbcad32.exe’ and click ‘ok’

    On Windows 8 and above
    Open the start menu and type in and open ‘Control panel’
    In the Control panel folder find and open the ‘Administrative Tools’ folder
    This may be located under ‘System and Security’

    In the ‘Administrative Tools’ folder open the ‘ODBC Data Sources (32bit)’ control panel

  • In the ‘ODBC Data Source Administrator’ control panel click the ‘Add’ button

  • Find the ‘PostgreSQL Unicode’ in the list of adapters (near the bottom) and click ‘Finish’

  • The setting for the driver should open, enter the following:
    Data Source: hackintosh
    Database: ltern
    Server: localhost
    User Name: <your user name provided by our database admin>
    Description: <anything>
    SSL Mode: disable
    Port: 5432
    Password: <your password provided by our database admin>

  • Click on the ‘Test’ button
    If the connection works it should report ‘Connection successful’

  • Click ‘Ok’
  • Click ‘Save’ in the settings window
  • Click ‘Ok’ to close the ‘ODBC Data Source Administrator’ control panel

The ‘hackintosh’ PostgreSQL ODBC driver should now be setup on your computer


Posts : 9
Join date : 2016-05-05
Location : Canberra

View user profile

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum