The following procedure (performed on your desktop PC) creates an UltraLite database using Sybase Central.
To create a database
From the Start menu, choose Programs » SQL Anywhere 11 » Sybase Central.
Use the UltraLite plug-in in Sybase Central to create a database in the same directory as your application. In general, the default database characteristics provided by Sybase Central are suitable. Note the following characteristics:
Database file name VBApp.udb or CSApp.udb, depending on your application type.
Collation sequence Use the default collation.
Use case-sensitive string comparisons This option should not be on.
Table name Type Names.
Columns Create columns in the Names table with the following attributes:
|Column Name||Data Type (Size)||Nulls||Unique||Default value|
|ID||integer||No||Yes (primary key)||global autoincrement|
Primary key Specify the ID column as primary key.
Exit Sybase Central and verify the database file is created in the required directory.
Link the initialized (empty) database file to your Visual Studio project so that the database file is deployed to the device along with the application code:
In the properties panel, set the Build Action property to Content; set the Copy to Output Directory property to Copy always.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|