How do I send a MySQL database to AYS?
You must first export (or dump) the MySQL database from the database server before it can be sent to AYS. Here are two options for creating that file to send to us.
10 articles Databases
Error -2147217900 [SQL Server]CREATE TABLE permission denied
When updating At Your Service – Repair Centre to the latest version, you may come across the above error. This article will help you resolve the issue and upgrade your SQL Server database to the latest version.
How to Configure MySQL for AYS
Specific MySQL server permissions are necessary for AYS users to access the data and run reports. Some additional permissions may be necessary for those that administer the AYS database on the server. This article will assist you in configuring the security on MySQL for both of these cases.
Error -2147467259 – MySQL “Malformed communication packet”
You may encounter the following error with MySQL Server 8.0.25 or below when adding a new record:
Moving AYS From One Server to Another
When you change or upgrade hardware you may wish to relocate the AYS application or data to another server. Depending on your edition and setup, you can follow one of the following procedures.
I get a “File already in use” error when opening an AYS database
When a second user opens an AYS Microsoft Access database that is already open by another user, they get a “File already in use” error message. This problem can be resolved by the following steps:
Database corruption message when starting AYS
When starting AYS software I see a message similar to the following:
Why does this happen, and what should I do?
Error -2147206396 – Not Supported
Error -2147024882 – Memory allocation error
MySQL System Requirements
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.