Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

The main purpose of this post is to show the process of connecting MySQL Database with SAP Crystal Report 2013 using 32 bit release of MySQL Connector/ODBC. Following steps might guide you through the process of connecting to a MySQL Database:

1. Install Wamp or XAMPP and create database "dbmysql" using phpMyAdmin

2. Download and Install MySQL Connector/ODBC (x86, 32-bit) - MySQL :: Download Connector/ODBC

3. Go to Control Panel > ODBC Data Sources.

4. Select the type of DSN you would like to create (User, System, File). Next, click Add.

5. Provide Data Source

6. Create New Connection - ODBC (RDO)

7. Select the newly created connection and through the arrow button push it to the Selected Table block

8. Select Next and then select the fields to be viewed in the report

9. Select the available template this is optional and then click on Finish.



10. Click on View in the menu bar select Preview or Preview Sample and you can find the data in the Crystal Report

Labels in this area