To create a database connection cache for the PostgreSQL database using the General method:
-
In the Database Configuration dialog box, select PostgreSQL from the Provider list.
-
Enter any text as the cache name.
-
Select the General tab.
-
Input the IP address (for connecting with the remote database) or machine name (for connecting with the local database) in Host.
-
Input the port number.
-
Enter your User name and Password for logging into the server.
The user name and password must have full-access rights so the compiler can access all tables and stored procedures and generate the C# models.
-
Enter your database name in Connect to a database.
-
Click View License Terms to view the driver license and then select the check box of "I have read and agree to the license ...".
For PostgreSQL, SQL Server, SQL Anywhere, or ASE, the corresponding .NET Core data provider is packaged with the IDE and will be loaded immediately after you have viewed and accepted the license terms.
-
Click Test Connection to make sure the connection is successful.
The "Allow dynamic connection using the transaction LogID and LogPass" option allows the application to use the LogID and LogPass property values of the Transaction object to log in to the database server (instead of using the values in the User name and Password fields). For more, refer to Using LogID and LogPass properties.