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.
You may encounter the following error with MySQL Server 8.0.25 or below when adding a new record:
Error when inserting data into MySQL
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.
At Your Service – Repair Center works with the following MySQL versions:
When working with a
MySQL database using an older ODBC 5.2 driver, a message similar to the following appears when attempting to print a report or form:
report was NOT displayed successfully
due to the following error: -2147206396 – Not Supported
MySQL databases may be installed natively on a Linux server.
Microsoft Access databases may be hosted on a Linux server using
Samba file sharing for Windows clients.
The AYS program itself was designed to work on
Microsoft Windows operating systems and is not officially supported on Linux desktop operating systems.
However, the AYS program can be run on a Linux desktop operating system by using one of the following methods:
The AYS program is
not compatible with emulated Windows environments on Linux (such as Wine).
When working with a
MySQL database using an ODBC 5.x driver, a message similar to the following appears:
Error: -2147024882 – [MySQL][ODBC 5.1 Driver][mysqld-5.5.25a]Memory allocation error
Error: -2147024882 – [MySQL][ODBC 5.1 Driver][mysqld-5.1.66-0 ubuntu0.10.04.3-log]Memory allocation error
The following is how to connect from a desktop to an existing MySQL server on your network.
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.