In the version of UltraLite installed with SQL Anywhere Studio
9.0.2, the lowercase -s parameter
defines a database schema for a new database, but earlier versions
required an uppercase -S. Because
PocketBuilder keeps in step with the latest database versions, the
Database painter utility for creating an UltraLite database automatically
inserts the parameter -s in
front of the database schema before it creates the database. This
works for UltraLite 9.0.2, but if you do not want to install the
9.0.2 EBF, you must change this parameter to -S and
run the database creation script from a command line.
Even without the 9.0.2 EBF, you can still use the Database
painter UI to obtain the UltraLite database creation script. After
you run the utility to create an UltraLite base and it fails, the
script used by the utility displays in the Output view in PocketBuilder.
You can copy this script, modify the -s parameter,
and run the script from a command line.
| Copyright © 2006. Sybase Inc. All rights reserved. |
|
|
