In the version of UltraLite installed with SQL Anywhere Studio
9.0.2, the lowercase -s parameter
is used to define a database schema for a new database, but earlier
versions required an uppercase -S.
Because PocketBuilder remains 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 that you select before it creates the database. Although
this works for UltraLite 9.0.2, 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 © 2005. Sybase Inc. All rights reserved. |
|
|
