The PocketBuilder 2.5 setup program includes an option for installing SQL Anywhere® 10.0.1. SQL Anywhere 10.0.1 includes the SQL Anywhere (formerly Adaptive Server™ Anywhere or ASA) and UltraLite® relational database systems, as well as the MobiLink™ synchronization server.
You can use either version 9.x or 10.0.1 SQL Anywhere components
with PocketBuilder 2.5. Changes to PocketBuilder allow you to select
and use the latest versions of these components, although SQL Anywhere
10 is now the default selection where a choice is required. For
example, although you do not need to add the driver=dbodbc10.dll parameter
to a DSN file specifying a SQL Anywhere 10 database, you must include driver=dbodbc9.dll in
a DSN file specifying an ASA 9 database.
The PocketBuilder setup program installs the ASADemo_10 database in the Code Examples\SADemoData\SA10 directory. This database is a migrated version of the Adaptive Server Anywhere 9 Sample database that you can use with SQL Anywhere 10. (It is slightly different from the demo database that installs with SQL Anywhere 10.) You must create an ODBC data source name for this database in the ODBC Administrator before you can connect to it at design time.
Upgrade to SQL Anywhere 10.0.1
The ASADemo_10 database was
created with the SQL Anywhere 10.0.1 version that installs with
PowerBuilder®. It cannot be used with SQL Anywhere 10.0.0.
Although you can connect to SQL Anywhere 10.0.0 databases with SQL
Anywhere 10.0.1, the reverse is not true. You must upgrade to SQL
Anywhere 10.0.1 to use the ASADemo_10 database.
If you use UltraLite 10 in the design time environment, you must copy UltraLite DLLs from the SQL Anywhere Ultralite\Win32\386\lib\vs7 directory to the main PocketBuilder directory. In PocketBuilder 2.5, the UltraLite Synchronization wizard has been upgraded to work with UltraLite 10 databases, as well as with UltraLite 9 databases.
