FAQ and Troubleshooting
Summary
How To
Connecting from different locations over the Internet
Troubleshooting Database Connection
Fixing Corrupted Access Database
MySQL Server Performance Optimization
Errors
'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.'
Unable to load file or assembly
Operation must use an updateable query or OleDbException: Unspecified error
Font ... does not support style ...
System.Exception: DatabaseInfoBaseCollection.Import failed. ---> System.Xml.XmlException: Root element is missing.
There is a problem with Adobe Acrobat/Reader. If it is running, please exit and try again (523:523)
MySql.Data.MySqlClient.MySqlException: Too many connections.
Details
1. Go to the Help tab on the Ribbon and click Activate.
2. In the License Wizard, click Request License Key. The email editor opens.
3. Enter the Order ID from Share-it. The Order ID will be in the mail you receive while buying the program.
4. Send the email. You will receive a response within one business day.
After receiving the License key from us
1. Go to the Help tab on the Ribbon and click Activate.
2. Copy the key from the email and to the License Key field in the License Wizard.Ensure that there are no extra spaces between the characters.
3. Click OK.
You can choose to install the database server automatically or manually. For more details, see Installing MySQL in the network
Connecting from different locations over the Internet
The Virtual Private Networking (VPN) is the basis of having a central server and remote computers connecting to it from different physical locations. One of the remote computers can act as server if it is convenient. VPN is a secure software that facilitates a network connection between two or more computers through the Internet. The setup and running of such as system is very easy, and similar to running a chat client.
For more details, see Connect over the Internet
To change the active currency in the program follow the steps:
1. Go to Administration->Currencies and Search your currency, eg. FJD
2. Select the row with the currency in the table and click Edit on the toolbar
3. In the opened window, check the Is Active Currency and press Save and Close
4. Next set your currency the default currency in the program, by going to Billing->[Company]Account->[Company] Editor and here selecting the activated currency ( eg. FJD ) in the Currency box. To finish press Save and Close
Note that you have to do these steps only once, and they will have effect for all user of the program
Troubleshooting Database Connection
While testing the connection from database connection wizard fails, follow these steps to solve the problem:
Step 1
Ensure that the entered database information is correct. Click Test Connection. Proceed to the next step if the connection is still not working.
Step 2
Ensure that the workstation has network access to the server machine. You can check this by searching for the server machine in the workgroup computers.
The network access problem here can be caused by:
- Hardware network problems
- Firewall on the workstation
- Firewall on the server
To eliminate the possible firewall problem, disable the firewall on both server and workstation temporarily, until you test the connection.
Contact the network administrator if necessary to make possible the connection between the workstation and server.
If the connection is still not working, proceed to the next step.
Step 3
Ensure that the MySQL instance on the server is running. To do this, install the MySQL Tools specified in Required Files.
Then press Start – Programs – MySQL – MySQL System Tray Monitor. Right-click the tray icon and check if the instance is running. If it is not running (stopped), click Start Instance.
Go to step 1 and restart the connection.
Fixing Corrupted Access Database
If the MS Access database is corrupted, you can recover and repair the database or delete the database.
To recover the database
To recover the database, it is recommended to use MSAccess or Jet compact utility (http://support.microsoft.com/kb/295334) to repair the database from the path specified in the error.
To delete the database
If you do not want to recover the database, you can delete the database file (db.mb) from the path specified in the error, and run the program. The database is located in:
Windows XP - C:\Documents and Settings\[You User Name]\Application Data\[Company]\Patient Manager ...\
Windows Vista or higher - C:\Users\[You User Name]\AppData\Roaming\[Company]\Patient Manager ...\
If you have installed the application for all users, the database is located in:
Windows XP - C:\Documents and Settings\All Users\Application Data\[Company]\Patient Manager ...\
Windows Vista or higher - C:\Users\All Users\AppData\Roaming\[Company]\Patient Manager ...\
MySQL Server Performance Optimization
MySQL can be optimized to handle large loads, for example large databases or large number of concurrent workstations:
1. Stop the MySQL service, typically from Control Panel->Administrative Tools->Services
2. Edit the my.ini file, typically located in the MySQL installation folder, e.g. "c:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini"
In the my.ini file, identify the keys bellow, and increase their values:
innodb_buffer_pool_size=8M we suggest increase to 600M, 1000M, 2000M or 10000M . Recommended 70% of total memory if dedicated server
thread_cache_size=8 we suggest increase to 50
innodb_log_buffer_size=1M for large transactions we suggest increase to 10M or 32M
Other setting you can tweak is innodb_log_file_size
3. Re-Start the MySQL service
If the values entered at point 2 are too large, MySQL service will fail to start. In that case , we recommend entering lower values, or restoring the initial state of the my.ini file. We cannot recommend fixed values for the settings, as they may differ from installation to installation
You can also use specialized tools to determine the right configuration for you server, for example the https://tools.percona.com/
MySQL Server - slow to login
When IP conflicts are present in the network, you may experience slow starting of the program
1. Stop the MySQL service, typically from Control Panel->Administrative Tools->Services
2. Edit the my.ini file, typically located in the MySQL installation folder, e.g. "c:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini"
In the my.ini file, in the [mysqld] section add the line:
skip-name-resolve
3. Re-Start the MySQL service
'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
The error 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.' is displayed due to an invalid installation of MDAC. In such cases, install the prerequisite program from our web site and then run the installation.
Unable to load file or assembly
The error ' Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies.'is displayed due to an invalid installation of Microsoft .NET.
To solve the problem:
1. Go to Control Panel and uninstall Microsoft .NET
2. Re-install .NET. You can install it from the prerequisite program (VertikalSystems.Prerequisites.exe).
Operation must use an updateable query or OleDbException: Unspecified error
The error 'Operation must use an updateable query' is displayed due to lack of permissions on the Access database file and the folder containing it.
To solve the problem:
1. Locate the database folder, typically at:
Windows XP - C:\Documents and Settings\[You User Name]\Application Data\[Company]\Patient Manager ...\
Windows Vista - C:\Users\[You User Name]\AppData\Roaming\[Company]\Patient Manager ...\
If you have installed the application for all users, the database is located in:
Windows XP - C:\Documents and Settings\All Users\Application Data\[Company]\Patient Manager ...\
Windows Vista - C:\Users\All Users\AppData\Roaming\[Company]\Patient Manager ...\
2. Set this permission, right click on the folder (or whichever other folder you have put the mdb file in) and select Properties. Look for the Security tab. If you can't see it, you need to go to My Computer, then click Tools and choose Folder Options.... then click the View tab. Scroll to the bottom and uncheck "Use simple file sharing (recommended)". Back to the Security tab, you need to add the relevant account to the Group or User Names box. Click Add.... then click Advanced, then Find Now. The appropriate account should be listed. Double click it to add it to the Group or User Names box, then check the Modify option in the permissions. That's it. You are done.
Font ... does not support style ...
The cause of the error is a corrupt or missing font on your system.
To solve the problem, go to you Windows\Fonts directory and find the font ( eg. Tahoma.ttf ). Copy it to another directory. Right-click on copied file and from pop-up menu select Install, and then restart the program.
System.Exception: DatabaseInfoBaseCollection.Import failed. ---> System.Xml.XmlException: Root element is missing.
The error means that the file that stores (PatientManagerDatabaseConnection.xml) the database connections is corrupted.
If you still experience the error, please delete that file. The steps are:
1. Identify the file by searching with Start->Search for PatientManagerDatabaseConnection.xml
2. Once identified simply delete it and run the program again. Note that you may need to import or recreate connection to you existing databases if you created extra databases
There is a problem with Adobe Acrobat/Reader. If it is running, please exit and try again (523:523)
The error in an internal error of Acrobat Reader. To resolve this issue, open Acrobat Reader. Next go in the preferences of your Acrobat X Reader, go to the "General" settings, and uncheck "Activate the protected mode at startup"
MySql.Data.MySqlClient.MySqlException: Too many connections.
The error means that MySQL is set to accept a fixed number or connections, and that limit has been reached.
The solution is to extend in MySQL the max number of connection - https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html
[mysqld]
max_connections=10000