Sybase’s PowerBuilder 5.0

Setting the Database Preferences

At this time, you must un-select the ‘Use Powersoft Repository’ checkbox in the Database Preferences dialog. This capability will be available with catalogues in a future release.

1. Select Database from the toolbar.

2. Uncheck the Use Powersoft Repository box.

Creating a new library

1.

2.

3.

4.

5.

Creating a new project

To use your ODBC data source

1.  Add a new Database profile that references your ODBC data source.

2.  Select the data source as your current Database Profile.

3.  Create a DataWindow.

4.  Select the fields you want to display.

5.  Place the DataWindow on your form and write a script attached to a button to fill it.

transaction abc

abc=create transaction

abc.dbms=’ODBC’

abc.dbparm=”CONNECTSTRING=’DSN=MSDB’,
CONNECTOPTION=’SQL_DRIVER_CONNECT,SQL_DRIVER_
NOPROMPT'”

connect using abc; dw_1.settransobject(abc)
dw_1.retrieve()
Running this application should allow you to see your dataset.