Before creating your Data Share connection you will first need to download and install a MySQL OleDB driver. We recommend downloading the MyOleDB driver from Sourceforge.
...
- Click on the Configure Source Database button.
- When you select the Provider tab you should be able to select the MySQL OLEDB Provider from the list.
- On the Connection tab
Data Source
Enter the name of your MySQL database
Location
Enter the name of the server where your MySQL database resides.
Enter information to log on to the server
Select the radio button Use a specific user name and password and enter the User name and Password for Data Share to connect to the database.
...
- Once you have entered the data use the Test Connection button to check that you have entered the details correctly and then click OK.
Name
Enter a name for your MySQL connection.
SQL
The next task is to select the table and fields from the database that you wish to use. You will need to know the name of the table as you need to manually do a "SELECT * FROM table". Enter a FROM statement followed by the table name from which you wish to select your fields and then click on the Construct SQL button.
...