Top

5.1.11.PostgreSQL

Datasource

Figure5.74.Datasource tab

Datasource tab

PostgreSQL Options

Figure5.75.PostgreSQL Options tab

PostgreSQL Options tab

  • Hostname. The hostname on which the PostgreSQL database server to be connected to is running on.

  • Port. The port number on which the PostgreSQL database server is running on the host machine. Defaults to 3306 if not specified.

  • Database. The database name to which the connection is to be made.

  • No Transactions. Disable ODBC transaction management. All transactions will be automatically committed. This prevents palloc() failures with out-of-memory errors when doing really big transactions such as Exporting 10000 records from MS/Access.

OpenLink Parameters

Figure5.76.OpenLink Parameters tab

OpenLink Parameters tab

ODBC Parameters

Figure5.77.ODBC Parameters tab

ODBC Parameters tab

Finish & Test

Figure5.78.Finish & test tab

Finish & test tab