How to connect to a MySQL Database in CardStudio

Article ID: 56444220

Details


 

Description

This solution is useful for:

  • Connecting to a MySQL database in CardStudio to load records.

 

Applies To

CardStudio Software

Requirements

CardStudio Professional Software

Overview

CardStudio Professional offers a strong selection of database connectivity options.  Using database connectors, CardStudio Professional can connect to many mainstream relational database services.  In this article we discuss how to connect to a MySQL database service using an ODBC driver.  The ODBC Driver for MySQL (Connector/ODBC) can be downloaded via the website in the following link  Read More>>.  

This article assumes that the a MySQL database service is up and running and that the ODBC Driver has been installed.

Procedure

We start by creating a simple card project in CardStudio.  For the sake of this article, we will simply load one of the card templates that comes with CardStudio Professional.  Notice that two generic text fields are already placed on the card.  Select either of these fields and choose the 'source' toolbar in the dashboard.  We will be selecting 'database source'.  If you are taken to a dialog entitled 'Select Column', this means you are already connected to a database.  To disconnect from this database, select the Database Menu > Disconnect.

User-added image

At this point we will enter Window's ODBC Data Source Administrator / Manager to make sure that our ODBC Driver has been installed and configured correctly.  Choose the 'ODBC Manager' button that appears:

User-added image

Under the 'System DSN' tab, choose your ODBC 5.1 driver.  In our example, we named the driver 'myodbc' during setup.  Select 'Configure'.

User-added image

Make sure that your database connection selections are accurate.  The configuration screen allows you to test your connection to ensure that the connection is valid.  In our example, we are using a database called 'employees', and are accessing the database as root.

User-added image

Once tested, you can close out the configuration screen and the ODBC Manager and return to the 'Select Database Source' window.  We will choose our ODBC driver ( 'myodbc' in our case) and hit next.  Notice that only 32-bit ODBC drivers appear in this list as CardStudio is a 32-bit applicaiton.  If you do not see your newly created driver on this list, please make sure you have installed the 32-bit version (even if on a 64-bit machine).

User-added image

The tables belonging to the 'employees' database should appear.  In our case, 'engineers' is the only table created.  Hit next.

User-added image

The data columns available in our table should now appear.  In our example, we have a 'firstname' column and a 'lastname' column.  We choose the 'firstname' column and hit 'Finish'.

User-added image

At this point, our first text field is now associated with the 'firstname' data column from our 'engineers' table in our 'employees' database.  Rotating through the records gives the user a way to quickly and easily bring up the same card populated with different data.

User-added image

 

Helpful Information

Download CardStudio Software Demo  Read More>>