FAQ

Veelgestelde vragen voor zelfhulp.

Bekijk snel de veelgestelde vragen (en antwoorden) in de standaardlijst. Als u niet kunt vinden wat u zoekt, begin dan met het selecteren van uw Ability Office -versie en verfijn deze dan door zoektekst en/of categorie in te voeren.

Zoeken naar

Selecteer categorie

Selecteer softwareversie

Kennisbank artikel 81

Can Database be used with MySQL

MySQL is a poweful Database Server that is used on many database driven websites - see http://www.mysql.com. Ability Database can be used to act as a "front end" - the application that displays and edits data. The following steps outline how to connect the two. It assumes that Ability Database is running on the local Windows PC and MySQL is running on a server (remote or local).

Download and install the MySQL ODBC driver. See: http://www.mysql.com/products/myodbc/.
Create a new ODBC data source: Goto Control Panel, Administrative Tools, Data Sources ODBC.
On the User DSN, select Add and select the MYSQL driver (if you can't see this, check instructions for step 1).
Give it a name: e.g. MySQLAbilityTest
Enter the server name, the database name, the username and password - you may have to contact your network adminstrator for these details.
Start Ability Database and create a new blank database.
Select File/Import and choose ODBC as the driver and OK
Select the Machine Data Source tab and choose MySQLAbilityTest
You should now see a list of tables (if not go back to step 5 and try the Test button)
Choose a table and, assuming you want to work with live data rather than import a copy of the data, select "Attach"

You can now use and edit the table as though it were a normal Ability table.