PocketBuilder installs with SQL Anywhere Studio tools that you can use to manage your application databases. SQL Anywhere Studio includes the SQL Anywhere (formerly Adaptive Server Anywhere) and UltraLite relational database systems, and the MobiLink synchronization server.
PocketBuilder supports SQL Anywhere databases through ODBC. With MobiLink you can synchronize data between a SQL Anywhere or UltraLite database and an enterprise database that uses SQL Anywhere or a different database management system, such as Oracle, Microsoft SQL Server, IBM DB2, or Sybase Adaptive Server Enterprise.
MobiLink can use a variety of protocols including TCP/IP, HTTP, HTTPS, and Microsoft ActiveSync to synchronize the consolidated database with the remote database on the handheld device. Synchronization can be bidirectional.
For information about MobiLink support in PocketBuilder, see Chapter 16, “Managing the Database,” and the chapter on MobiLink synchronization in the Resource Guide.
At design time, you use the Database painter in PocketBuilder to access SQL Anywhere or UltraLite databases and perform the following operations:
Modify local table and column properties
Retrieve, change, and insert data
Create new local tables or modify existing tables
Create a new database or delete an existing database
For information about using the Database painter, see Chapter 16, “Managing the Database.”
When you open a painter that communicates with the database (such as the Database painter or DataWindow painter), PocketBuilder connects you to the database you used last, if you are not already connected. If the connection to the default database fails, the painter still opens.
If you do not want to connect to the database you used last, you can deselect the Connect to Default Profile option in the Database Preferences dialog box.
You can change to a different database at any time. You can have several database connections open at a time, although only one connection can be active. The database components for each open connection are listed in the Objects view of the Database painter.
The Database painter title bar displays the number of open connections and indicates which is active. The title bar for each view displays the connection with which it is currently associated. You can change the connection with which a view is associated by dragging the profile name for a different connection onto the view.
