PocketBuilder connects to a database when you:
Open a painter that accesses the database
Compile or save a PocketBuilder script containing embedded SQL statements (such as a CONNECT statement)
Run an application that accesses the database
Invoke a DataWindow control function that accesses the database while executing an application
PocketBuilder uses a database profile to connect to the database you used last when you open a painter that accesses the database. It determines which database you used last and how to connect to it by looking at database profile settings in the registry.
A database profile is a named set of parameters stored in your system registry. Each profile defines a connection to a particular database in the PocketBuilder development environment. You must create a database profile for each data connection. You can:
Select a database profile to establish or change database connections. You can easily connect to another database at any time during a PocketBuilder session. This is particularly useful if you often switch between different database connections.
Edit a database profile to modify or supply additional connection parameters.
Delete a database profile if you no longer need to access that data.
Import and export profiles.
Because database profiles are created when you define your data and are stored in the registry, they have the following benefits:
They are always available to you in the development environment
Connection parameters supplied in a database profile are saved until you edit or delete the database profile
You can also use a database profile to generate the correct syntax to use in a script for a database connection.
