Opening MySQL databases

This page explains how to connect BaseNow to local or remote MySQL database.

   Step-by-step instructions

   Using OLE DB Provider for mySQL

   Using ODBC Driver for MySQL (via MyODBC)

Step-by-step instructions

1. Click the Open button and the ‘Data Link Properties' window will pop up.

2. On the 'Provider' tab, select 'Microsoft OLE DB Provider for ODBC Drivers', and click the 'Next' button.

3. On the 'Connection' tab, check the 'Use Connection String' option, and for the connection string, enter something like:

Driver={mySQL};Server=MyServerName;Option=16834;Database=mydb

Replace MyServerName with the name of the computer where MySQL is installed. Replace mydb with the name of the database you want to open.

4. Fill in your 'User Name', and 'Password', and check the 'Allow SavingPassword' checkbox ('Blank Password' should be unchecked):

5. Click 'Test Connection', and you should get a message saying 'Test Connection Succeeded'.

6. Click OK and the new database connection will appear in BaseNow:

The example above should work if you are connecting to MySQL installed locally. See the connection string properties for the remote connections.

Using OLE DB Provider for MySQL

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.

Using ODBC Driver for MySQL (via MyODBC)

To connect to a local database

Driver={mySQL};Server=MyServerName;Option=16834;Database=mydb

Replace MyServerName with the name of the computer where MySQL is installed. Replace mydb with the name of the database you want to open.
 

To connect to a remote database

Driver={mySQL};Server=db1.database.com;Port=3306;Option=131072;Stmt=;Database=mydb;Uid=myUse rname;Pwd=myPassword

Replace db1.database.com with the address of the MySQL server. Replace mydb with the name of the database you want to open.

Use your login information instead of myUsername and myPassword.

For more information and to download ODBC driver, click here.

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.