BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

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.

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2010 Oricode. All Rights Reserved.