You can create as many termbases as you need. For example, you might use one termbase for Client A, a different termbase for Client B, and yet another for Client C. When you create a termbase, it can be used in any of your Lingo projects.
Creating a termbase is different from adding a termbase (see Adding Termbases). Whereas creating a termbase generates a new, empty termbase, adding a termbase takes an existing termbase on your computer or server and adds it to the list of available termbases so that you can associate it with your Lingo project.
Select the Resources ribbon. In the Termbase section, select Create Termbase.
From the submenu, select one of the following:
- Local Select this option if you want to use SQLite for a local termbase. This option opens a simple dialog that lets you give the new database a name and choose where to store it. By default, the location for SQLite databases is in Documents\Lingo Termbases on your computer. However, you can choose a different location if you like.
Server Select this option if you want to use SQL Server Express for a termbase to be stored on a server. This opens a dialog with fields for the name, server, and security information related to the database.
Note: If you do not already have SQL Server Express installed and you try to install a server
termbase or servertranslation memory, Lingo will prompt you to install SQL Server Express 2012. This version of SQL Server Express is supported on Windows 7, Windows Server 2008 R2, and Windows Server 2008 Service Pack 2,. However, it is not supported on Windows 8. If necessary, you can manually install another version of SQL.
To download and install the latest version of SQL Server Express, go to:
Note: In order to create a server translation memory or termbase, you must have both db_datareader and db_datawriter roles , or you must have the dbcreator role. This is set in your SQL management tool.
In the following user mapping image, the user has both db_datareader and db_datawriter selected:
In the following server role image, the user has dbcreator selected:
For a server termbase, in the Name of new database field, type a name for the termbase. Next to the Database server field, click . The Connect to SQL Server dialog opens, displaying a list of usable servers after Lingo scans your network. In the Connection timeout field, you can adjust the number of seconds to allow a connection to the server to be successful. In the Authentication section, you can use Windows Integrated Security (the default), or you can enter a specific user name and password for the server (if necessary). If you elect to use Windows Integrated Security, leave the user name and password fields blank. Otherwise, if your server requires specific credentials, enter them in the fields provided.
- After completing the fields in the appropriate dialog, click OK.