This solution is useful for:
- Connecting to a MySQL database in CardStudio to load records.
CardStudio Professional Software
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.
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.
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:
Under the 'System DSN' tab, choose your ODBC 5.1 driver. In our example, we named the driver 'myodbc' during setup. Select 'Configure'.
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.
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).
The tables belonging to the 'employees' database should appear. In our case, 'engineers' is the only table created. Hit next.
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'.
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.
Download CardStudio Software Demo Read More>>