Using the Other PowerBuilder Database Interfaces

The benefits of connection caches in an n-tier environment are indisputable. Although you should strive to use connection caches whenever possible, existing code or other inviolable programming, schedule, or environmental constraints may require you to use connection interfaces supported by PowerBuilder but not by EAServer. These include the following PowerBuilder database drivers:

  • Microsoft SQL Server (MSS)

  • Informix (IN9)

  • Direct Connect (DIR)

  • Microsoft OLE-DB (OLE)

  • Sybase ASE (SYC)

These interfaces may still be used in an EAServer context; however, they must be used within components that are nontransactional, as illustrated in Table 19.3. If one of these database interfaces is used within a transactional ...

Get PowerBuilder® 9: Internet and Distributed Application Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.