Connect to the SQL Server database

 

With the SQL Server additional module, NDS is enabled to connect to a SQL Server database. This does not mean that your program will store all the data on the remote database, because the local copy of NDS will work with a local database.

The SQL Connection Settings allow you to connect or disconnect from the SQL Server database if needed. Also, if the connection to the server is not possible or allowed, your program will connect to the local database.

 

You can check your active connection in the bottom part of the NDS screen:

 

Main database

This will display the name of the server (in my example, KRAUN\SQLEXPRESS\) and the name of the database if connected to the SQL Server database; otherwise it will display the path of the local database (for example, C:\RUMEN\NDS3).

 

Icons

 

 à If this icon is displayed, you are currently connected to your local database, so your connection with the SQL Server is not possible or not configured well.

 

 à You are currently connected to a SQL Server database.

 

 à This icon should only work with Single User SQL Server usage. This mean that you are currently connected to a SQL Server database and your local database will be synchronized at the end of the session, with the changes you made on SQL Server database.


(See Database Synchronization for more details.)