|
The following procedure creates an UltraLite database using Sybase Central.
See Creating an UltraLite database from Sybase Central.
Start Sybase Central:
From the Start menu, choose Programs > SQL Anywhere 10 > Sybase Central.
Use the UltraLite plug-in in Sybase Central to create a database in the same directory as your application with the following characteristics:
Database file name VBApp.udb or CSApp.udb, depending on your application.
Collation sequence Use the default collation.
Case sensitivity Leave this option cleared.
Table name Type Names.
Columns Create columns in the Names table with the following attributes:
| Column Name | Data Type (Size) | Allow NULL? | Default value |
|---|---|---|---|
| ID | integer | No | global autoincrement |
| Name | varchar(30) | No | None |
Primary key Specify the ID column, ascending.
Link the initialized (empty) database file to your project so that the database file is deployed to the device along with the application code:
From the Visual Studio menu, choose Project > Add Existing Item.
Browse to the directory where you created the database file and select the file VBApp.udb or CSApp.udb depending on your application. Do not click Open.
Click the arrow in the Open button and click Link File.
In the Solution Explorer frame, right click the database file name that has just been added to the project and choose Properties.
In the properties panel, set the Build Action property to Content; if you are using Visual Studio 2005, set the Copy to Output Directory property to Copy Always.