Connect to a Database


Create new database 

Selecting System | Local database | Create new local database will take you to a dialogue for this purpose. REM. the term Local database refers to the database in your local network. 
The dialogue has the following options: 
  • Select database type - Select Microsoft SQL-server if you have either Microsoft SQL Server 2000, Server 2005 eller Server 2008 installed in your system and intend to use it for your DentalEye database. Microsoft Access database is suitable for networks up to about 5 concurrent users while SQL is recommended for use in larger networks. It is possible to convert an Access format database to a SQL database later if needed. As the SQL database is more complicated to install we recommend that it is only installed by experienced staff.  
  • Depending on your database type choice you will be presented options for this type: For SQL you must provide a Server name (the name of the computer where SQL is installed) and a Database name of your choice. For Access you must provide Path and file name for your database file. 
  • Image store path - this is the folder where your images will be stored. It does not need to be the same as where your database resides. 
  • Copy demo database from CD - if you check this option some patients, templates, images and toothgroups will be added to your new database. 
  • Add default templates - if you check this option some basic templates and toothgroups will be added to your new database. 
  • When clicking OK the database will be created and selected as your default choice. If you intend to use this database from all workstations in your network you must select the database on each one of them. 
    Make sure that you have a backup system covering the folders that you selected before you start using the system. 
    If you run SQL you must make sure that the database files are backed up properly. Consult your network supplier if you're not sure how to do this. 

    Local database info 

    Selecting System | Local database | Local database info; will open a window with information about the currently selected database. 
    You will see where the database is located and what version it is. (This version number is not the same as the version no of the program itself.) 
    You can also see how much free space you have in your Image stores. 
    Some statistics from the database is also presented including number of patient, images and templates. 

     
     
    Setting database 

    Selecting System | Setting database will open a dialogue where you choose your active database and edit the image store settings.  
    Most likely you will only use this function when installing the system. When creating your database on one workstation you will have to use Setting database to select the newly created database on the other workstations. 
    The dialogue has the following options: 
  • Select database type - Here you have to choose the same type of database used when creating it. 
  • User name/Password - Here you provide the login information for your SQL server. For Access databases this is currently not relevant. 
  • Depending on your database type choice you will be presented options for this type: For SQL you must provide a Server name (the name of the computer where SQL is installed) and then choose Database name from the list. For Access you must provide the Path and file name of your database file. 
  • Image store(s) for database - This is where you can administrate your image stores. An image store is a folder where images are stored. You can have more than one image store but only one selected as active. The active imagestore is where new images will be saved. The others are only used for retrieving old images. Please note: Currently you need read and write permissions both in the active and the non active image stores. It is possible to Add new image stores, Delete imagestores with no images in them and Change path (...) to an image store. 
  • The database selection is saved as default for the currently logged in user only. If you log in with a different username you will have to use Setting database for that user too. This is useful in the case where 2 users wanting different databases but work on the same PC.