The following screen illustrates a typical POSTGRESQL ODBC Connection:

Fields

Description

Connection name

Enter a name for the connection.

Connection type

Select ODBC from the drop-down list.

Database type

Select POSTGRESQL from the drop-down list.

ODBC DSN

Select SQL Server 2012 from the drop-down list.

Max simultaneous

Set the maximum number of simultaneous connections 3D will open to the system.

Manual tree expand

Select the checkbox to manually expand and load the database and host connections tree, instead of automatically drilling down the tree.

Windows Authentication

Select the checkbox to connect via Windows authentication. If unselected, then connection will be attempted using authentication mechanisms defined in the DSN.

User

Enter the username for connecting to the specific database.

Password

Enter the password for connecting to the specific database.

Store password in

Select one of the following options if you choose to save or not to save your password:

  • Repository
  • Locally
  • Do not store

Test connection

Click the button to ensure the entered parameters are correct.

  • No labels