Opening database using OLE DB provider is little different. If you experience problems using ODBC method explained above try this method.
1. Click Open in BaseNow and in the �Data Link Properties� window on the 'Provider' tab, select 'MySQL.OLEDB Provider', and click the 'Next' button.
2. On the 'Connection' tab, enter the MySQL database name as the
'Datasource', and the Server name as the 'Location'.
3. Check the 'Allow Saving Password' and 'Blank Password'
4. Click OK and you should see a new database connection in BaseNow.
When you right click the connection in the Object Browser and choose Properties, the connection string should look like this: Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword
For more information, see: SWSoft, and Snippet. The OLE DB provider can also be downloaded from MySQL web site.