We will be using the sample food mart database for all tutorials. Please look into the introduction blog to obtain the link for this database.
In this post we look at creating a datasource to the foodmart database in MySql. The screenshots are from a windows XP machine.
Steps to create the data source.
1. Goto Start -> Control Panel -> Administrative Tools
2. Click on Data Sources (ODBC). The datasources window will open.
3. Click on system DSN tab (second tab).
4. Click on Add.
5. Select MySql from the list.
If the MySql ODBC driver is not available download and install it from
http://dev.mysql.com/downloads/connector/odbc/5.1.html
6. Provide the connection details
6. Click on OK. The datasource is created and is available for use.