Below are the possibilities of installing the program on the web, when choosing we have to think about which one will best meet our expectations. The program will need a server with a MySQL or MS SQL database.
If we want the program to work on several computer workstations connected to the Internet and use common data such as: common numbering, price lists, list of companies, list of documents
We have several solutions to choose from:
I) (Payable PLN 150 gross/year) Purchase of hosting and configuration of the MySQL database server by us on our server (PLN 150 gross/year)
If you do not have a computer or a purchased hosting that can serve as a server, you can purchase external hosting from us, on our servers.
After purchasing the server, you will receive from us the access data to the database, the name of the database, the user name and the password.
Enter the sent data as in Figure 1. In Faktura VAT 2020 program, select Settings -> Basic -> Program configuration, branch “Access paths/Documents”, here select one by one as in the photo.
II) (Free for advanced users) Installation of MS SQL or MySQL database server on your own server
It is a solution for people who have their own computer that acts as a server
Installation Description:
1) we install the MS SQL or MySQL server on our own server or purchased from us or another service provider.
(applies to installation on your own server) For this purpose, we can download its free version from the web or download our automatic installer (for Windows 7 and 8) MS SQL server installer. After installation, configure the program as shown in the figure below.
Database Name: Rafsoft Username: SA Password: admin1234
If you are installing a MySQL server, you will also need the MySQL ODBC Connector driver (32bit version), you can download it from our website http://ksiegowosc24.pl/pliki/mysql-connector-odbc-5.3.4-win32.msi
2) in Faktura VAT 2020 program, select Settings – > Basic -> Program configuration and then the Configuration/Access paths/Documents branch, here select one by one as in the photo. Below is an example of the program configuration:
Figure 1
5) after clicking Save, the Export button will appear, which we can use (optionally) to transfer the already entered data to the remote server
6) after performing the export, restart the application
III) Other option (without installing MS SQL server – we do not recommend this solution)
It is sharing files on the system and configuring the paths to the shared files in the client programs accordingly.
A video showing how to configure Faktura VAT 2002-2016 program on the web.
On the computer that will serve as a data server (share data), we do what is shown in this video – http://rafsoft.nazwa.pl/centrumsms-com-pl/prezentacje/prezentacja4.avi.
now we make the c:/database directory available in Windows so that it can be seen by our other computers in the network
On the remaining computers, in the Invoice/Configuration/Access paths option, we set the locations for Data and Invoices to the catalog that we created on 1 computer (server)
Required codec (for video): http://download2.techsmith.com/tscc/TSCC.exe
