| Home | Previous Lesson: Database Profiles Next Lesson: System Options |
Profile Name is the name given to a profile and is used whenever you want to connect to the database. PowerBuilder creates a section with this name in the pb.ini file. Data Source is the ODBC datasource name. 'product' in this case. ODBC and its data sources are explained in the next session in detail. User ID is the valid ID used to connect to the database. This user id should exist in the target database and the provided password should match, otherwise, the ODBC driver manager will prompt you for the correct user id and password at run-time.
Driver-specific parameters, DBPARM, which is used to specify any database specific parameters that are not listed in any of these tab pages. Please refer to the back-end database server manuals for more information.
You don't have to create separate profiles for every database that you want to connect to. If you check on 'Prompt for Database information' option, you'll be prompted to provide database connection information at run-time.
AutoCommit controls whether PowerBuilder issues SQL statements outside or inside the scope of a transaction. When set to true, PowerBuilder issues SQL statements outside the scope of a transaction and vice-versa. Transactions are explained in detail in the later sessions. Please note that, changing the AutoCommit value after connecting to the database has no effect on that connection.
Commit On Disconnect option decides whether PowerBuilder should commit or rollback all uncommited transactions at disconnect time. The default is true and leave it as it is.
Turning on Generate Trace option generates a tracelog file for all the database activity. This option is explored in depth in 'Debugging PB Apps' session.
| Home | Previous Lesson: Database Profiles Next Lesson: System Options |