server program on the network.
B.2 T ESTING N ETWORK C OMMUNICATIONS
To test whether the communication works, you can use various test utilities, or you can try to establish communication between the server program and the client.
One utility you can use with TCP/IP is ping. You use ping to check whether the server computer is reachable over the network. From the client computer, use the ping <host> command to check whether the TCP/IP connection is OK.
Establishing Communication between the Server and Client
To test the communication between the server program and the client program, you must start the server program.
Starting the Server
Switch to the disk on which the server program is installed and then to the directory in which the server program is installed.
Start the server program with the following three property settings:
servername=<servername>
nettype=<nettype>
database=<database path>
Server Name
If you don't specify a server name, the server program will default to Server1. You can enter any name, but make sure that all clients are started with the same server name. Also make sure that when TCP/IP is chosen as network protocol, the hosts and services files use the same server name. When using TCP/IP, the server name in the hosts file on the client is used instead of the server name provided on the command line.
Net Type
Net Type should either be netb, when NetBIOS is used, or tcp, when TCP/IP is used.
Database
<database path> should contain the full path to the database.
EXAMPLE
An example of starting the server program under Windows is:
server servername = FinServer, nettype = tcp, database=d:\fdb\database.fdb (written as one command)
Starting the Client
After the server program has been started without problems, start the client program. The important program properties for the client program are Server Name and Net Type. It is a good idea to specify these properties in the Target field of the Navision
Properties window. (Read more about this on page 47.)
When you start the client program with the proper server name and net type, you should be able to communicate with the server program. If you have any problems, check the communication setup.
A
Active Directory
adding schema extension . . . 18
and Navision . . . 92
definition . . . 142
security . . . 90
security, features . . . 91
adding a Navision Server to MMC . . . . 43
Advanced window . . . 58
application object, see object Application Objects 114, 116, 118, 119, 121 contents . . . 121
part of database . . . 98
restoring entire backup . . . 119
restoring into empty database . . . 56
authentication . . . 90
Database Server . . . 91
definition . . . 90
program property . . . 32
selecting . . . 32
specifying on client when opening a database . . . 58
B B+ trees (balanced trees) . . . 83
Backup window . . . 114
backup advanced information . . . 120
all companies . . . 115
automatic under Windows NT . . . 116
before date compression . . . 75
contents, data type . . . 121
custom . . . 115
definition . . . 142
effect of database size . . . 117
entire database . . . 115 errors in . . . 112 extent of . . . 115 file description . . . 115 file extension .fbk . . . 115 file location . . . 115 file name . . . 115 in a network . . . 113 preparing for . . . 114 procedures for . . . 112
restoring, see restoring a backup
status window . . . 116
system for making . . . 112
testing before . . . 117 verifying . . . 116 when to make a . . . 112 backup file description . . . 120 header in . . . 120 BLOB definition . . . 142 bottleneck detecting . . . 136–138 hardware level . . . 137 software level . . . 136 C C/SIDE definition . . . 142 cache commit see commit cache
definition . . . 142
locations of different types . . . 136
object, see object cache
program property . . . 39
specifying size during installation . . . 16
Change Password window . . . 105
changing the installation . . . 10–11 checksum header . . . 120 master . . . 120 client computer requirements . . . 3 definition . . . 2, 26, 142 installing . . . 4–9 client/server . . . 2, 26 definition . . . 142
close forms on Esc program property . . . 37
command line . . . 142
defining program properties . . . 47
commit cache bottleneck, software level . . . 136
database in several files . . . 52
definition . . . 142
for server . . . 39
program property - client and single-user 33
relationship to (DBMS) cache . . . 39
specifying size during installation . . . 16
status, checking . . . 67
companies, maximum number . . . 50
company automatic selection . . . 47
moving to a different database . . . 55
opening automatically . . . 31
program property . . . 31
selecting on client . . . 59
specifying in Target field . . . 48
Company Data, contents . . . 121
compressing a database . . . 74
computer choice of . . . 131
requirements, single-users and clients 3 concurrency . . . 85 connecting to server . . . 30 controller correction scheme . . . 132 RAID system . . . 132 requirements . . . 130, 131 CPU definition . . . 142 requirements . . . 130, 134 CRONUS International Ltd. . . . 50
cronus.flf, demonstration license file . . 50
Current Sessions . . . 68
current sessions details . . . 68
number of . . . 68
custom setup Backup of Demo Database . . . 7
Business Notification Manager . . . 7
Commerce Integration . . . 7
Demo Database . . . 7
Help . . . 7
MDAC . . . 7
MSDE . . . 7
Navision Gantt Server . . . 7
Navision Toolbar for Outlook . . . 7
Custom Setup window . . . 8
D Data Common to All Companies 114, 118, 119, 121 contents . . . 51, 114, 116, 121 part of database . . . 98
restoring entire backup . . . 119
restoring into empty database . . . 56
data version definition . . . 86 database altering . . . 59 amount used . . . 66 automatic selection . . . 47 automatic start . . . 30 closing . . . 60 compression . . . 74 connection to . . . 67 creating . . . 51–55 creating space in . . . 74
data compression, backup function 114
default on starting . . . 59
deleting completely . . . 65
deleting part of . . . 65
deleting, warning about . . . 64
expanding . . . 53–55 expanding a working . . . 82
guarding against loss . . . 51
in one file . . . 52 in several files . . . 52 information about . . . 66 list of tables . . . 70 location . . . 67 maximum size . . . 52
minimum size for restoring backup . 121 modifying . . . 2
name . . . 66
name (when several files) . . . 55
number of companies in . . . 50
opening from within application . . . 57
opening with program property . . . 59
program property . . . 30
program property, on server . . . 39
selecting . . . 30
selecting during installation . . . 17
setting up for server . . . 20
size . . . 2, 52, 67 size and application performance . . . 53
size purchased . . . 67
specifying on client when opening a database . . . 58
standard . . . 20, 56 status, checking . . . 66
testing . . . 61
testing, backup function . . . 114
transferring single-user database to the server . . . 20
two or more servers . . . 21
utilization . . . 70 Database File table . . . 137 database file creating an extra . . . 55 expanding . . . 54
Database Files window . . . 66
Database Information (Keys) window . . . 71
Database Information (Tables) window 71
Database Information window . . . 66
Database Key Groups window . . . 72
database login assigning a role . . . 100 creating . . . 95, 96 definition . . . 143 description . . . 90 expiration date . . . 96 giving a role to . . . 96 password . . . 96 time-limited . . . 96 Database Logins window . . . 95
specifying on client when opening a database . . . 58 database server dedicated . . . 143 definition . . . 143 non-dedicated . . . 145
database server authentication definition . . . 143
Database Server Manager . . . 43
Database Sessions window . . . 68
database test before application opens . . . 35
custom . . . 62
errors, handling . . . 63
from within the program . . . 61
levels . . . 35, 61 maximum . . . 62
minimum . . . 61
normal . . . 62
unopened database . . . 61
database.fdb (standard database) . . . . 50
date compression backing up database before . . . 75
batch jobs . . . 75 description . . . 75 example . . . 77–79 options . . . 76 result of . . . 75 setting filters . . . 76 starting . . . 75 db read-only program property . . . 38 DB test program property . . . 35 DBMS definition . . . 143
DBMS (Database Management System) cache allocation . . . 67
bottleneck, software level . . . 136
maximum size . . . 137
size required . . . 136
swapping . . . 40, 136 dedicated database server . . . 143
dedicated server definition . . . 143
delete (permission) . . . 99
in Permissions window . . . 102
delfin.log see log file demonstration company . . . 19
access to . . . 80
CRONUS International Ltd. . . 50
naming . . . 50
demonstration database . . . 2
demonstration license file cronus.flf . . . 50
restrictions . . . 19, 50, 80 single user . . . 19, 80 DHCP (Dynamic Host Configuration Protocol), server . . . 135
disk cache definition . . . 143
DNS (Domain Name System), server . 135 domain definition . . . 143
publishing Navision Server in a . . . 18
domain controller definition . . . 143
domain tree definition . . . 143
publishing Navision Server in a . . . 18
E equipment, choosing . . . 3 equipment, PC, choosing . . . 3 errors in database . . . 63 transmission . . . 53 execute (permission) . . . 99 in Permissions window . . . 102
Expand Database (Advanced) window . 55 Expand Database window . . . 54
expanding a working database . . . 82
Export License File window . . . 81
F fbk, extension of backup file name . . . 115
filter, on status bar . . . 36
fin.flf (license file) . . . 50
forest definition . . . 143
publishing Navision Server in a . . . 18
H hard disk capacity . . . 132 requirements . . . 130, 131 speed . . . 132 hardware optimization . . . 130 selection . . . 131 hardware performance table . . . 137 header checksum . . . 120 hibernation . . . 88 conditions preventing . . . 88 restarting after . . . 88 host name . . . 144 HOSTS file . . . 135, 144 HotCopy backup description file . . . 124, 126 command prompt parameters . 123, 124 output . . . 127
restoring . . . 127
I
ID, user
changing . . . 105
ID, user setup program property . . . 29
saving setup . . . 29
index, sorting key . . . 62
Insert (INS), on status bar . . . 36
insert (permission) . . . 99
in Permissions window . . . 102
Install as service description . . . 42
entering on the command line . . . 46
install as service program property . . . 42
installation cancelling . . . 4
changing . . . 2, 10–11 changing, repairing and removing . . . 10
client . . . 4–9 complete . . . 6 custom . . . 6, 6–9 custom, options . . . 9 expanding . . . 2 license file . . . 17 minimum . . . 5 multiuser . . . 6 procedure, description . . . 4–9 rollback . . . 4 selecting database . . . 17 server . . . 13–18 server, maintaining . . . 18 single-user . . . 4–9 upgrading . . . 11 installation upgrade custom . . . 12 new . . . 12 typical . . . 11
internal node, in tree structure . . . 83
K key group . . . 71
disabling . . . 73
setting up . . . 72
keys changing sorting order . . . 62
deactivating or removing . . . 71 definition . . . 144 information about . . . 71 predefined . . . 71 primary . . . 62 secondary . . . 62 L lazy write caching system . . . 132
lazy-write cache leaf, in tree structure . . . 83
level 2 cache definition . . . 144 license file changing . . . 81 checking validity of . . . 81 client . . . 19, 80 cronus.flf . . . 19, 80 demonstration, limitations on . . . 50 exporting . . . 81 fin.flf . . . 19, 50, 80, 81 if it expires . . . 81 importing . . . 80 installation . . . 17 multiuser installation . . . 19 single user . . . 19 your own . . . 50
License Information window . . . 80
license number . . . 80
Licensed Sessions . . . 68
log file (delfin.log) . . . 11
log on, log off definition . . . 144 login definition . . . 90 M machine name HOSTS file . . . 135
network configuration program . . . . 135
marquee full selection program property . . . 37
master checksum . . . 120
memory computer . . . 144
ECC (Error Correction Code) type . 134 requirements . . . 133
Microsoft Management Console . . . 14, 43 MMC . . . 43 modify (permission) . . . 99 in Permissions window . . . 102 multiuser installation definition . . . 144 described . . . 26 description . . . 2, 26 installation of single user . . . 2
N name backup file . . . 115
database . . . 66
database (when several files) . . . 55
database, specifying on client when opening a database . . . 58
printer . . . 110 server, specifying on client when creating
user, changing . . . 105
Navision service connection point, adding definition to Active Directory . . . 18
Navision backup starting to restore . . . 118
Navision Database Server Manager . . . 43
Navision security initiating . . . 95
Navision Server importing a database into . . . 20
installing . . . 13
maintaining . . . 18
naming . . . 15
publishing . . . 18
renaming . . . 18
selecting the network protocol . . . 16
status . . . 45
updating . . . 18
net tests, network optimization . . . 138
net type program property, on client . . . 34
program property, on server . . . 39
program property, specifying on client 58 NetBIOS . . . 144
network protocol . . . 134
two servers . . . 23
network adapter, requirements . . 130, 134 network configuration program, machine name . . . 135
network optimization, net tests . . . 138
network protocol advantages and disadvantages . . . 135
checking . . . 67
definition (under NetBIOS) . . . 144
NetBIOS . . . 134
requirements . . . 130
selecting during installation . . . 16
TCP/IP . . . 134
network server definition . . . 144
network type selecting during installation . . . 16
New Database window . . . 51 new database naming . . . 51 specifying size of . . . 52 new users creating, database login . . . 95
creating, Windows login . . . 98
NEW, on status bar . . . 36
node, in tree structure . . . 83
non-dedicated database server definition . . . 145 O object definition . . . 102 permissions . . . 102 types . . . 102 object cache allocation . . . 67
bottleneck, software level . . . 136
definition . . . 145
memory requirements . . . 145
program property . . . 33
size required . . . 137
object cache (program property) performance . . . 33
setting size of . . . 33
objects, list of those with permissions 103
Open Database window . . . 58
operating system for client/single user . . . 3
for server . . . 3
requirements . . . 134
selection . . . 131
optimistic concurrency . . . 85
Overtype (OVR), on status bar . . . 36
P password changing . . . 105
entering . . . 58
entering when creating database login . 96 if lost . . . 106 new . . . 105 security . . . 90 PC, choice of . . . 3 Performance Monitor . . . 137, 138 Performance table . . . 137 permissions adding users . . . 100
creating new roles . . . 99
delete . . . 102
deleting . . . 99
execute . . . 99, 102 for objects . . . 102
giving a role to a database login . . . . 97
giving a role to a user . . . 97
giving to existing users . . . 100
granting to users . . . 98
groups, description . . . 93
indirect, definition . . . 102
insert . . . 99, 102 limiting posting periods . . . 108
modify . . . 99, 102 modifying for a role . . . 101
modifying for individual objects . . . . 101
modifying for multiple objects . . . 103
read . . . 99, 102 restricting to specific companies . . . . 97
standard . . . 98
standard, list of . . . 101
superuser . . . 96
time-limited . . . 93
to multiple objects, granting . . . 103
types of . . . 99, 102 who can administer . . . 95
Permissions (All Objects) window . . . 103
Permissions window . . . 101
PING command, TCP/IP . . . 135
posting limiting periods . . . 108
time limits for users . . . 93, 107 printer name . . . 110
selecting see printer selection
printer selection default . . . 93 description . . . 110 fixed . . . 93, 110 printer name . . . 110 report ID . . . 110 report name . . . 110 user ID . . . 110 program properties for clients, description . . . 29
for server, list of . . . 39
specifying in target field . . . 46–48 table of . . . 28
program property authentication . . . 32
cache . . . 39
close forms on Esc . . . 37
commit cache, client and single-user 33 commit cache, for server . . . 39
company . . . 31
database . . . 30
database, on server . . . 39
db read-only . . . 38
DB test . . . 35
defining in command line . . . 47
definition . . . 145
ID, user setup . . . 29
install as service . . . 42
marquee full selection . . . 37
net type, on client . . . 34
net type, on server . . . 39
object cache . . . 33
quick find . . . 38
server name, on client . . . 30
server name, on server . . . 39
sessions . . . 41 status bar . . . 36 stoptime . . . 40 temppath . . . 34 testtarget . . . 35 protocol definition . . . 145 selection . . . 131
protocol, see network protocol . . . 145
publishing Navision Server . . . 18
Purchase Responsibility Center filter user setup . . . 108 Q quick find program property . . . 38 R RAID definition . . . 145 requirements . . . 130 system, configurations . . . 133 system, controller . . . 132 read consistency . . . 85 permission . . . 99 read (permission) in Permissions window . . . 102
registering time use . . . 93
reinstalling server . . . 18
Restore window . . . 118
Restore window . . . 57
restore, advanced information . . . 120
restoring a backup all companies . . . 119 constraints . . . 120 custom . . . 119 entire . . . 119 example . . . 121 extent . . . 119 limiting extent . . . 119
minimum size of database . . . 121
monitoring . . . 57
problems . . . 121
procedure . . . 118–119 using built-in function . . . 118
using other restore functions . . . 118
role creating a new . . . 99
definition . . . 145
entering ID . . . 99
giving to database logins . . . 96, 100 giving to users . . . 96
giving to Windows group . . . 104
giving to Windows logins . . . 100
giving to Windows Users and Groups 103 modifying permissions for . . . 101
roles list of . . . 97 rollback definition . . . 145 of the installation . . . 4 of the uninstallation . . . 10
root, in tree structure . . . 83
S Sales Responsibility Center filter user setup . . . 108
schema definition . . . 145
schema extension adding to Active Directory . . . 18
security additional features provided by Active Directory . . . 103
creating new roles . . . 99
level of . . . 93
seek time, optimizing . . . 74
server automatic connection to . . . 47
automatic timed stop . . . 40
computer requirements . . . 3
connecting to . . . 30
dedicated . . . 143
definition . . . 2, 26, 145 DHCP (Dynamic Host Configuration Protocol) . . . 135
different databases . . . 21
DNS (Domain Name System) . . . 135
installation . . . 13–18 installation, maintaining . . . 18 naming . . . 15 network . . . 144 non-dedicated . . . 145 operating system . . . 3 reinstalling . . . 18 renaming . . . 18 selecting . . . 30
specifying in Target field . . . 48
specifying on client when creating a database . . . 51
specifying on client when opening a database . . . 58
starting . . . 20
updating . . . 18
server based backup see HotCopy Server Manager . . . 43
server name designating . . . 15
program property, on client . . . 30
program property, on server . . . 39
specifying on client when creating database . . . 51
specifying on client when opening database . . . 58
server package . . . 2
server program, installing . . . 20
service connection point definition . . . 146 Navision . . . 18 session, definition . . . 146 sessions current number of . . . 68 description . . . 41 number allowed . . . 41, 68 program property . . . 41 terminating . . . 68 setup definition . . . 146
fixed printer selection . . . 110
single-user . . . 29
setup file, see zup file . . . 26
single sign-on definition . . . 146 support of . . . 90 single-user computer requirements . . . 3 converting to client . . . 6 definition . . . 2, 146 in multiuser installation . . . 2 installing . . . 4–9 setup . . . 29 single-user installation description . . . 26 snap-in . . . 43 installing . . . 14
sorting keys, predefined . . . 71
sorting order . . . 62
space allocation in database testing . . . 62 standard database . . . 20 database.fdb . . . 50 restoring . . . 56 restoring a backup . . . 51 standby . . . 88 conditions preventing . . . 88 restarting after . . . 88 start command . . . 48 status Navision Server . . . 45 status bar program property . . . 36 stoptime closing a database . . . 60 description . . . 40 program property . . . 40 superuser definition . . . 96 granting permissions . . . 96 setting up . . . 96 swapping definition . . . 146
swapping, DBMS (Database Management System) cache . . . 40, 136 T table finding errors in . . . 74 optimizing . . . 73, 83 Table Information - Sort window . . . 71
table seek time improving . . . 73 tables in database . . . 70 Target field definition . . . 146 program properties . . . 48 specifying company . . . 48 specifying server . . . 48 start command . . . 47 TCP/IP network protocol . . . 134 PING command . . . 135 two servers . . . 21
temporary files, location . . . 34
temppath (program property) . . . 34
Test Database window . . . 61
Test Space Allocation . . . 62
Test Tables window . . . 74
testtarget program property . . . 35 time limits for company . . . 109 on posting . . . 93, 107 on user IDs . . . 93, 107 time use, registering . . . 93, 107–108, 109 time used, on user IDs . . . 107
time-limited permissions . . . 93 transmission errors . . . 53 tree structure . . . 73 U uninstall as service description . . . 42
entering on the command line . . . 46
program property . . . 42 uninstalling Navision . . . 10 rollback . . . 10 updating server . . . 18
upgrading the installation . . . 11
user ID and user setup file . . . 27
changing . . . 105
creating . . . 96
current displayed on status bar . . . 93
displayed on status bar . . . 109
of super user . . . 96
on G/L entries . . . 93, 109 time-limited . . . 93, 107 user name changing . . . 105
when creating database login . . . 96
User Setup window . . . 107
user setup Purchase Responsibility Center filter 108 Sales Responsibility Center filter . . 108
Warehouse Location filter . . . 108
user setup file creating . . . 29
individual . . . 36, 37, 93, 109 location . . . 27
returning to original . . . 29
saving . . . 27, 29 User Time Registers window . . . 109
user time, registering . . 93, 107–108, 109 W Warehouse Location filter user setup . . . 108
window Advanced . . . 58
Backup . . . 114
backup function, status . . . 116
Change Password . . . 105
Custom Setup . . . 8
Database Files . . . 66
Database Information . . . 66
Database Information (Keys) . . . 71
Database Information (Tables) . . . 71
Database Key Groups . . . 72
Database Logins . . . 95
Database Sessions . . . 68
Expand Database . . . 54
Expand Database (Advanced) . . . 55
Export License File . . . 81
License Information . . . 80
New Database . . . 51
Open Database . . . 58
Permissions . . . 101
Permissions (All Objects) . . . 103
Restore . . . 57, 118 Roles . . . 97, 101 Table Information - Sort . . . 71
Test Database . . . 61
Test Tables . . . 74
User Setup . . . 107
User Time Registers . . . 109
Windows Logins . . . 100, 104 Windows Users and Groups . . . 98
windows authentication definition . . . 146
Windows login assigning a role . . . 100 creating . . . 98 definition . . . 146 description . . . 90 Windows Logins window . . . 100, 104 Windows Users and Groups giving a role . . . 103
window . . . 98
write back system . . . 132
Z zup file each user has their own file . . . 26
returning to original . . . 29