1.1.5 Tab: Database

1. Please select the Microsoft™ Database (e.g. MS Access or MS SQL Server) for translation in the Connection String grid via the small browse button . A configuration dialog for Data Link Properties will appear:
   
   
    

2. On this dialog you will have to select the OLE DB Provider which is used to access your Microsoft™ database:
   Please select Microsoft Jet 4.0 PLE DB Provider if you want to translate a MS Access Database.
   Please select Microsoft OLE DB Provider for SQL Server if you want to translate a MS SQL Server Database.
   
   Confirm your selection by clicking on the button Next >>. Then the tab Connection will be selected:
   
    

   For Microsoft™ Access Databases:	For Microsoft™ SQL Server Databases:

    
3. Select or enter database name by using the small browse button or enter a server name by opening the combo box at item 1. 
   
4. Enter information to log on to the database at item 2. This access data (User name and Password) is only necessary if the database does not allow each user to access the database.

   If you can not access your MS SQL Server database please try to use the User Name: sa with an empty Password.

    
   
5. For MS SQL Server databases (dialog on the right side) you will also have to Select the database on the server (see item three).
   
6. Confirm your settings by clicking on the button Test Connection.
   In case that your connection settings were correct a message "Test connection succeeded." If not please contact the creator of the database to get the correct access data.
   
7. Finish your configuration by clicking on the OK button at the Data Link Properties dialog. Visual Localize will write automatically your configurations into the Connection String grid.
   
8. On the New project dialog please also confirm your settings by clicking on the OK button. A dialog to configure your database tables for translation will be opened:
   
   
   
   
9. Depending on the kind of storage from your language dependent phrases please select the tab control Language in Columns or Language in Rows.
   Samples:
   
   Language in Rows:
   ID  |  LangID |   Phrases
   -----------------------------------------
   1   |  1         |   Open
   1   |  2         |   Öffnen
   1   |  3         |   Ouvrir
   
   Language in Columns:
   ID |   PhrasesEN |  PhrasesGE  |  PhrasesFR
   ------------------------------------------------------------------------------
   1  |   Open          |  Öffnen          |  Ouvrir
   2  |   Close         |  Schließen     |  Fermer
   3  |   Data           |  Daten           |  Données
   
10. Via the Table browser combo box you will get a preview of the selected table for an easier configuration in step 11:
    
    
    
11. At the second grid you will have to configure, your database tables:
    
    
    
    • In column Tables please select the name of your database table.
      In our sample the table is named ErrorTexts.
      
      Visual Localize can only translate database tables containing a primary key!
      In case that your tables does not have a primary key, these tables are not visible. Here the creator of the database should add a primary key to identify each record unique.
      In addition to this all configured Microsoft™ databases (e.g. MS Access, MS SQL Server) will NOT be imported physically into the localization project (*.prj). During the creation of the target files, Visual Localize will use the original source database to write back the translated phrases. In case that a different user (not the user who created the localization project) wants to write back the translated database phrases, the Connection String (see step 7 above) must be re-configured for his computer.
      
    • In column LangID Fields please select the identifier which is used to differentiate between all languages.
      In our sample the LanguageID is used to separate each language
      
    • In column LangID Source please select the unique identifier from your source language.
      In our sample the LangID Source is 1 for German language.
      
    • In column LangID Target please select the unique identifier from your target language.
      In our sample the LangID Target is 2 for English language.
      
    • In column Text Field please select the column from your database table which contains the source phrases.
      In our sample the columns "Fehlertext1" and "Fehlertext2" contain the phrases for translation. This is also the reason why we have to configure these two database columns.(One for "Fehlertext1" and one for "Fehlertext2". See below.)
      
      
      
12. Confirm all you setting by clicking on the OK button. Visual Localize will import all phrases from your database tables into the localization project.