Josytal DB Applications SharePoint: Known Problems and Solutions (FAQ)

Below are some known problems and offered solutions that have helped users as at the time of compiling this documentation. More answers to questions and problems are continually added to the list, and available online at : http://www.josytal.com/faq.html or on specific product's webpage

Problem	Possible solutions

Can't connect to Josytal DB Applications SharePoint database	Make sure the port you are using for connection is not occupied (busy) by another application on your system. Use the built-in utility to determine busy ports and choose any free port number If you have Josytal DB Applications SharePoint and database installed on separate computers, then make sure between the two computers there are no unresolved restrictions regarding network permission, firewall, SQL or database authentication issues Make sure you have correctly installed and configured MS SQL Server database on your system Josytal DB Applications SharePoint can work with or without a on SQL Server Database. So if you are having problems with SQL Server database then try the single-file database option. In fact, most small and medium businesses take advantage of Josytal DB Applications SharePoint flexibility and have opted for single-file database, due to its simplicity.

Can't connect to Josytal DB Applications SharePoint from client application, e.g. from A-Z Contacts Manager NT. Instead, I got the following messages: pic.1 pic.2	Message error with dialog Socket Error #10061 (pic.1) means Josytal DB Applications SharePoint is not running on the server computer, when you made attempt to connect to it from your computer or remote computer. Message error with dialog Socket Error #10053 (pic.2) means you were initially connected to the server computer, but somewhere along the line, your computer lost connection to the server computer. It can also mean that you were about to do some things that could have possibly led to data corruption and violation errors, like trying to edit read only records, when you don't have the rights and privileges in the system to do so. Make sure the port number you have specified in the client application's Database connection parameters settings is the same as the one being successfully used by Josytal DB Applications SharePoint on the server computer. Verify that you have the correct host (Network IP) specified in the client application's Database connection parameters settings. The value must correspond to the host (Network IP) of the server computer, where Josytal DB Applications SharePoint has been installed. If Josytal DB Applications SharePoint and client application are installed on the same computer, then the correct host value should be "localhost" or 127.0.0.1 If they are on different computers, then host should read something thus: 269.154.104.xxx Again, the host value is the server computer Network IP, where Josytal DB Applications SharePoint has been installed and not the client's application IP - if they are installed on different computers. From Josytal DB Applications SharePoint use the built-in utility to auto-detect the server computer host (network IP Address). In order to detect correct network IP address, during the process, make sure the computer is connected to and active in the local area network . Also make sure the computer is disconnected from internet, as this may lead to displaying a wrong value If Josytal DB Applications SharePoint and client application are installed on separate computers, then make sure between the two computers there are no unresolved restrictions regarding network permission, firewall etc Verify from the administrator your user's rights to access the database and your privileges in the system.

I can't use my old database from single-user version for the multi-user version	The two versions are incompatible, because they use different database structures and approaches to accessing and processing data. If you have single-user version installed, you can not later on jump or upgrade to multi-user version or vice versa. They are two separate products and must be treated as such. Once you have multi-user version installed, more and more users/workstations can be added later on in future to access a common database through the local area network

I have been using Josytal DB Applications SharePoint with Access single-file database, now I want to transfer my database to MS SQL Server	There are many software available for handling the task. We will recommend BullZip MS Access to MSSQL. It will convert your Access file to SQL on the fly. In our opinion, it is simple to use, fast and reliable. Above all, it is free. Check this link: http://www.bullzip.com Wishes: If you can, please make some donations to them afterwards, to keep up the good job, although donation is not mandatory.

The more the number of users I add to connect to Josytal DB Applications SharePoint, the slower data retrieval through the network becomes	This is natural. In any network, data processing speed is directly proportional to the number of users concurrently accessing the database. However, system overall performance will depend largely on the capacity of your LAN adapter. Please refer to recommended capacity in the installation requirements. If you have a low-powered adapter, you should replace it with more robust one. Again, if you have 10 or more users, you should consider moving your database to MS SQL Server.

What is "Connection Closed Gracefully" message	The message is displayed when any unexpected data processing error has occurred. The message informs that access to a table data has been temporarily denied or blocked. It is one of the measures taken to uphold data integrity. It is better to close connection instead of corrupting the table or database. As a rule, this affects only one or two tables at a time (and there are over 100 tables in the database). So you can continue to work with other tables. After a while, connection will again be established. Alternatively, click the Refresh or Show All button to try and connect again.