Database Profile Edit

The database profile edit window is used to add or change a database profile. It is opened from the Database Profile window. The window looks slightly different if you are working on an ODBC connection.

This is the ODBC version of the window. The first dropdown lists all ODBC datasources defined on your system. The second dropdown identifies the type of database it is.

This is the version of the window used for the other supported types:

For ODBC connections PBSearch automatically adds the DBParm DisableBind=1 if the parm is not present. This is done to prevent database errors on some Microsoft SQL Server databases.

The Use PowerBuilder password option allows PBSearch to use the password directly from the profile created in PowerBuilder. If your password changes, you just update it in PowerrBuilder and PBSearch automatically uses the latest value. PowerBuilder stores the password in the registry and encrypts it. PBSearch is able to decypher the password stored by PowerBuilder.

The OK button will save the profile to the registry. The Cancel button closes the window without saving changes.