Creating a new database
To create a new database, choose from the main menu File
 Database
New.... A dialog window will apear on the screen.
Dropdown list Choose database provider contains all available database engines.
Depending on program version it may be Microsoft Jet (Access)
and/or Microsoft SQL Server / Microsoft Desktop Engine (MSDE).
When you have chosen the database provider click Next >.
Another dialog window will apear, depending on the selected provider:
Microsoft Jet or Microsoft SQL Server.
| Microsoft Jet (Access) |
|
Enter path to the database file to be created. If you don't provide
file extension, program will add extension .anu.
It is the standard extension for uplook's database format.
You may also click button Browse... to have the file selection dialog opened.
When you have entered database file path click
Finish to proceed to the last phase of database creation.
|
| Microsoft SQL Server / Microsoft Desktop Engine
(MSDE) |
List
SQL Server contains all available Microsoft SQL servers.
The system does not always allow to list all existing servers.
If your server is not listed, enter its name manualy.
Name of the database to create should be entered in field Database
.
Frame Connection properties contains all options
necessary for succesful authorisation on SQL server.
There are two ways of authorising:
- Windows authorization - Username
and password used during login in Windows will also be used to
login to SQL server.
- SQL Server authorization - You have
to provide your own username and password to authorize in
SQL server. Use fields Username and Password.
If you check field Remember username and password you won't
have to provide them each time you start uplook.
When you have entered path database file path click
Finish to proceed to the last phase of database creation.
If the opening database fails,
there are four probable reasons. If any of those cases takes place,
it may be have to be nesessary to contact server administrator.
- SQL server does not exist,
is not running or is not physicaly connected to the network
(network failure).
- Specified user does not exist.
- Specified password is incorrect.
- Specified user does not have
required priviledges to modificate the database.
|
After you have chosen and accepted parameters of a new database
you will see a dialog window showing details of database creation process.
A list in the window will print SQL commands as they are being sent to
the database server. When the operation is complete the window will be closed
automaticaly.
Newly created database will be instantly opened and set as default.
It will be opened automaticaly on program start.
|
