The Database page > Basic tab has the following settings:
|
Option or option group |
What you specify |
|---|---|
|
Provider |
Select the database provider for connecting with the application database. The database connection will be used at application deployment and runtime. The database connection is required 1) when converting the PowerBuilder DataWindow objects to PowerServer C# models during the deployment process; and 2) when accessing data from the database at application runtime. See Configure the database connection for more details. |
|
Cache name |
Specify a name for the database connection cache. This cache will be automatically mapped to the SQLCA transaction object. |
|
(various database connection settings according to the selected provider) |
The connection settings may vary from the database provider. For connection settings for each database provider, refer to Walkthrough: Connecting to the Database. |
|
"Database driver" group |
If you have selected the "I have read and agree to the license terms of the driver shown above" option, the corresponding database driver will be downloaded from NuGet site automatically to the development PC and the PowerServer whenever necessary. See Select the database driver for more details. |
|
"Additional settings" group |
Click the More button to configure the additional settings of the database connection. |
The Database page > Advanced tab has the following settings:
|
Option or option group |
What you specify |
|---|---|
|
"DB connection profile" group |
Create various DB connection profiles which include database connections to be used in different environments, for example, database connections for the development environment, testing environment, production environment, etc. See Create DB connection profiles for more details. |
|
"Database connection" group |
Click New to create a new database connection cache or click Edit to modify an existing cache. See Configure the database connection in the Database Configuration dialog for more details. |
|
"Transaction-to-cache mappings" group |
Map the transaction object with the database cache. See Map the transaction object with the cache for more details. |
