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.