Creating a database profile

To create a new database profile for a database interface, you must complete the Database Profile Setup dialog box for the interface you are using to access the database.

To create a database profile for a database interface:

Select View>Database Painter from the Visual Studio menu bar.

The Database painter displays. The Objects view lists your installed database interfaces.

Where the interface list comes from When you run the Setup program, it updates the Vendors list in the registry with the interfaces you install. The Database painter Objects view displays the same interfaces that appear in the Vendors list.

Highlight an interface name and select New profile from the pop-up menu.

The Database Profile Setup dialog box for the selected interface displays. For example, if you select the SYC interface, the Database Profile Setup - Adaptive Server Enterprise dialog box displays.

Client software and interface must be installed To display the Database Profile Setup dialog box for your interface, the required client software and native database interface must be properly installed and configured. For specific instructions for your database interface, see the chapter on using the interface.

On the Connection tab page, type the profile name and supply values for any other basic parameters your interface requires to connect.

For information about the basic connection parameters for your interface and the values you should supply, click Help.

About the DBMS identifier You do not need to specify the DBMS identifier in a database profile. When you create a new profile for any installed database interface, DataWindow Designer generates the correct DBMS connection syntax for you.

(Optional) On the other tab pages, supply values for any additional connection options to take advantage of DBMS-specific features that your interface supports.

For information about the additional connection parameters for your interface and the values you should supply, click Help.

(Optional) Click the Preview tab if you want to see the connection syntax that DataWindow Designer generates for each selected option.

You can copy the connection syntax from the Preview tab directly into your code.

For instructions on using the Preview tab to help you connect in a DataWindow .NET application, see the chapter on using transaction objects in the Programmer’s Guide.

Click OK to save your changes and close the Database Profile Setup dialog box. (To save your changes on a particular tab page without closing the dialog box, click Apply.)

The database profile values are saved in the system registry in HKEY_CURRENT_USER\Software\Sybase\DataWindowDesigner\2.5\ DatabaseProfiles\PowerBuilder.

You can look at the registry entry or export the profile as described in “Importing and exporting database profiles” to see the settings you made. The NewLogic parameter is set to True by default. This setting specifies that the password is encrypted using Unicode encoding.