Database Connection

LinkedPOS Express

Congratulations!. No action required. Everything is set-up by the setup program for you. Simply start using LinkedPOS Express and enjoy the benefits. The database is maintained in a file on local computer at its default location i.e. Installation Directory->Data->LinkedPOS-en.sqlite3. If due to any reason the database file is required to be moved to any other location on local computer then read the SQLite section.

However, if you are interested in connecting to database of your choice, then please contact support@ABCDevForce.com.

LinkedPOS Professional

LinkedPOS Professional is developed based on the Microsoft technology stack therefore the backbone of this program is Microsoft SQL Server. However, LinkedPOS Professional can be connected to internal database also but in this case it will work as a standalone. Sales terminals will not be able to connect to the internal database.

LinkedPOS Professional is meant to work on multiple computers where the BackOffice is installed on one computer on the local network while the sales terminal can be installed on unlimited number of computers on the local network. For setting up database connection, read through the following sections:-

SQLite (Standalone Mode)
SQL Server (Multi-station Mode)

Connection Setup with SQLite

LinkedPOS Express is using SQLite as its database engine thus making it possible to create a one click installation and zero configuration deployment. Simply install and start using LinkedPOS Express without any type of configurations. However, LinkedPOS Professional can also be connected to SQLite but in this case it will work as a standalone. Sales Terminals will not be able to connect to the internal database.

When LinkedPOS Express is started for the first time, the database does not exist and LinkedPOS Express itself creates a database under the "Installation Directory->Data" folder. No configuration is required. However if due to any reason the database is required to be moved to any other location then the following instructions can be used to configure connection.

1 :The default DBMS type (Database Management System Type) is SQLite but it can be changed to Microsoft SQL Server by choosing one of the options displayed in dropdown list as shown in the image below:-

2 : Default Authentication for connecting to database is Database. Since SQLite supports database authentication only therefore other options are not valid. All available options can be observed in the below image:-

3 : SQLite is embedded into the database with zero footprints. That's why it can run on the local computer only and the Server is local the computer's name and cannot be changed.

4 : Database name must be provided. Default database is "Installation Directory->Data->LinkedPOS.sqlite3" but it can be changed to any other name and location. On startup, LinkedPOS will check for tables and if tables are not found, then LinkedPOS will create the tables.

5 : No User is required to connect to SQLite database. Leave it blank.

6 : No Password is required to connect to SQLite database. Leave it blank.

When the information mentioned above is provided, then validate this information by pressing the button and all discovered instances will be displayed in the dropdown list. Simply select the target instance and press the OK button. Connection success or failure messages will be displayed accordingly. If the test connection is successful, then press the and connection information will be permanently stored. For closing the connection dialog press the button.

Connection Setup with Microsoft SQL Server

LinkedPOS Professional is developed based on the Microsoft technology stack and therefore the backbone of this program is Microsoft SQL Server. However, LinkedPOS Professional can be connected to an internal database also but in this case, it will work as standalone. Sales Terminals will not be able to connect to internal database.

When LinkedPOS Professional's Back Office is started for the first time, the database does not exist and database connection dialog will appear in the image below. Connection settings must be provided for LinkedPOS to work properly.

1 : The default DBMS Type (Database Management System Type) is Microsoft SQL Server but it can be changed to SQLite by choosing one of the options displayed in dropdown list as shown in the image below:-

Database Management System Type SQL Server

2 : Default Authentication for connecting to database is Windows. An alternative option for connecting to database is authenticaion mechanism that is mangaged by the database management system itself. Both options can be observed in the image below:-

3 : Default Server is the local machine and Default SQL Server Instance (MSSQLSERVER). Microsoft SQL Server may be on any other computer on the network. In order to discover all installed instances of Microsoft SQL Server on the local computer as well as all computers available on the network click the button and all discovered instances will be displayed in the dropdown list. Simply select the target instance and press the OK button.

4 : The database name must be provided. The default database is LinkedPOS but it can be changed to any other name. On startup, LinkedPOS will check for tables and if tables are not found, then LinkedPOS will create the tables.

5 : User depends on theAuthentication type. If the authentication type is Windows, then the User is not required. But if the authentication type is Database, then User's name must be provided.

6 : Password depends on the Authentication type. if Authentication type is Windows then the Password is not required. But if the Authentication type is Database, then the Password name must be provided.