Audioworxs Database
Frequently Asked Questions for Audioworxs Database

There were 7 questions found in this category:
  1. Recommended MySQL version for use with Audioworxs.
    When building an Audioworxs system that uses the MySQL database engine and the MyODBC driver do not simply get the latest versions available on the MySQL website. Problems that manifest themselves as
    occasional Job Server stoppages have been encountered with some versions of MySQL and MyODBC. ...

  2. Are there any setting changes required when using MySQL?
    To use a MySQL database with Audioworxs you must use version 1.00.019 or greater of Job Server and 1.00.013 or greater of Call Manager. Also, on workstations running Call Manager or Job Server you will need to use version 3.5x.xx of MyODBC and set the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Datawor...

  3. Does Microsoft SQL allow the system to run much faster than if using Access?
    The "industrial strength" database engines like SQL Server and MySQL will provide a speed advantage when dealing with a large number of records but may not be noticeable in smaller systems. The "industrial strength" database engines will, however, provide better record integrity than Access, whi...

  4. When using Microsoft SQL Server (or any other database requiring licensing) how can I determine how many licenses I need?
    Licensing for third party database engines is generally based on how many clients will be accessing the database directly OR INDIRECTLY. Even though all clients are funnelled through the Job Server and will technically work with a single client license you should determine how many client stations m...

  5. What databases does Audioworxs support?
    Because all the Audioworxs applications use an industry standard ODBC interface the databases can be one of many types. The Audioworxs applications "talk" to the ODBC driver and therefore don't need to know what the underlying database is. Dataworxs has tested Audioworxs using SQL Server 2...

  6. How can I save existing data when changing from one database to another?
    To save existing data, run Backup Manager before making the database change, select all tables and do a backup. Make the database change following the appropriate instructions. After successfully creating the new database tables run Backup Manager, select all tables and do a restore. License informa...

  7. Does SQL Server need to be installed on the same computer as Audioworxs Job Server?
    No. Job Server accesses the database via an ODBC Data Source. The Data Source can be configured to log into a local SQL Server installation or a remote SQL Server. If connecting to a remote SQL Server it is even more important to consider user authentication and database and table permissions and ri...