Gasboy Fleet Head Office System - Manual (Page 70)

68
NOTE
ODBC Microsoft SQL Server Setup is part of MS
Windows installation, therefore the procedure is not
described in this manual.
Figure 3-46. SQL Server DSN Configuration
3. If the user manages a small fleet using SQLEXPRESS software, make sure that the
definition in the ‘Server’ box is ‘.\SQLEXPRESS’
4. Click ‘Next’ and follow the instructions until the connection can be tested
5. Repeat the same procedure for HO_LANG and HO_META_DATA
6. In order to use a language other than English, change the language in the Head Office Setup
screen. If the change has been made but the correct fonts do not appear open SQL Studio
and run the following scripts in ‘C:\Orpak\HeadOffice\DB\mssql’: ‘LANG_drop.sql’
followed by ‘LANG.sql’ then ‘META_DATA_drop.sql’ followed by ‘META_DATA.sql
Database collation needs to be set to
SQL_Latin1_General_CP1_CI_AS.
Only Username and Password are case sensitive.
FMS and FHO User’s Manual - MDE-4821l