beautypg.com

Figure 3-46. sql server dsn configuration – Gasboy Fleet Head Office System User Manual

Page 70

background image

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