#Postgresql odbc driver cursor with hold install

Select the driver or data source name you added in the previous steps.Įnter the user name to use when connecting.Įnter the password to use when connecting. Note: Specify a user that has been granted SELECT privilege in pg_catalog schema. Review the following for additional information: Specify the remaining connection properties in the Create New Connection dialog.

Specify the configuration properties required for the database in the Windows driver setup dialog.

Select a PostgreSQL ODBC driver from the list, and click Finish.

To create a data source to use in this connection, click in the Data Source Name field.

Or select a driver and enter a ConnectionString. Select a driver and enter a server name, port number, and a database.

To create the connection without using a data source, clear this check box to display driver names.

To create the connection using a data source, select this option to display data source names.

Select PostgreSQL from the Group list box.

For example, 64-bit Toad requires an applicable 64-bit driver and 32-bit Toad requires an applicable 32-bit driver. To create a successful ODBC connection, the architecture (bitness) of the driver in the specified DSN must match the architecture (bitness) of Toad.

#Postgresql odbc driver cursor with hold install

You can connect with or without using a data source name (DSN).ĭownload and install the necessary ODBC driver to use for your PostgreSQL connection prior to creating the new connection in Toad. Toad Data Point allows you to easily create a connection to a PostgreSQL database using ODBC connectivity.

Storage Performance and Utilization Management.Operating Systems Imaging and Deployments.