Accessing data sources

(CR #533120) When accessing these predefined EAServer data sources from PowerBuilder components, set the default transaction object (SQLCA) to use the appropriate database type as shown in Table 2.

Table 2: Database type

Database type

Description

JCM_Sybase

For ASE database:

sqlca.dbms="SYJ"

JCM_Oracle or JCM_Oracle_Unicode

Oracle database which corresponds to the EAServer 5.x Oracle Call Interface (OCI) 9 and OCI10 native connection caches.

sqlca.dbms="O90", or

sqlca.dbms="O10"

JCM_Odbc or JCM_Odbc_Unicode

For any databases using ODBC driver:

sqlca.dbms="ODBC"

JCM_non-JCM JDBC-compliant

For any non-JCM JDBC-compliant database type:

sqlca.dbms ="JDBC"