This is one of the questions comes to in my mind when I first tried to work with visual basic 6. 0 (vb6) and backend as mysql database.

Actually its required to install the mysql odbc connector. Which you can find on the mysql website. Ok here is the link for the mysql odbc connector

http://dev.mysql.com/downloads/connector/odbc/5.1.html

Just select the appropriate driver for instance windows and I always select windows

- Windows MSI Installer (x86)

Download by clicking on the link/mirror available on the right site of the above text.

After downloading the odbc connector for mysql double click on your machine to install it by following the screen instructions(installation wizard).

Your mysql odbc connector is installed and ready to use.

How to  check that your driver is installed properly.

Go to Control Panel

Go to Administrative Tools

Double click on Data Source(ODBC) icon

Click on Drivers Tab and Check that “MySQL ODBC  5.1 Driver” is available in the list of all ODBC drivers.

Then you can use the following simple code in visual basic 6.0 (vb6) to connect to the database.

Beginning of  vb code

Dim strConnectionString As String

Dim tconnection As ADODB.Connection

Dim trecord As ADODB.Recordset

Dim slct As String

  strConnectionString = “DRIVER={MYSQL ODBC 5.1  DRIVER};SERVER=localhost;

DATABASE=yourdatabasename;

PORT=3306;

UID=username;

PWD=password;OPTION=3″
   Set tconnection = New ADODB.Connection
   tconnection.ConnectionString = strConnectionString
   tconnection.Open

   slct = “select * from tablename”
      
  Set trecord = New ADODB.Recordset
  trecord.Open slct, tconnection

End of vb code

It is done, but don’t forget to create database, user, tables in the mysql.

To do that following this link.

How to install MySQL on your windows based pc or computer

Installation Procedure 

Step-I

Download the MySQL server latest version from the MySQL site, according to your operating system, in this case this is Windows the version I have tried is for Windows XP.

http://dev.mysql.com/downloads/

From the above link select the latest version of MySQL and for windows select the

Windows MSI Installer – link.

Step-II

When download finish then run the file mysqlXXXXXX.msi file and follow the instructions.

That is it installation of MYSQL is so simple, with in the two minutes it will be ready to use.

Step-III

Your next step is to run the MySQL service configuration wizard to provide the password for the root user of the database.

When you are done then start using MySQL .

How to use?  Or  Hands on MySQL.

Few commands and instructions for your initial how to use mysql database is here.

What is MySQL?

Why am I selected this topic?

Always there are lot of queries about the databases available in the market especially when you like to have a big relational database system (RDBS) based application. There are many RDBMS system available in the market at present.  

Brief Introduction

Here I am talking about the one which is having GPL or free source licensed, you are absolutely right! This is none other than MySQL database.

It is so popular in the online world that almost 60% of the websites running on this RDBS system. Any dynamic website cannot afford to run without this MySQL.

Application of MySQL

As I mention in the above section the application of the MySQL database mostly online dynamic websites along with another power language PHP for the website development is used more often on the websites. Especially with the web hosting service provider is having Linux as their server operating system.

Of course nobody can deny the application for the corporate and government sector for their robust applications they are using MySQL as their backend system.

Another application is in the education field where big schools and universities are moving rapidly towards MySQL because of overall cost and maintenance and its functionality.

Let us summarize the applications of the MySQL database:

1. Online websites
2. Corporate Sectors
3.  Government Organizations
4. Educational institutions

MySQL as the new passion

My new passion related to MySQL is developed, because I am supporting students for their final semester’s IT projects. So since 2006 students want to use MySQL as the backend for their project. Till now I was working on website development where MySQL is the popular backend used.

This time I have to use MySQL on my PC based applications because of some of the students they are using MySQL  as I mention earlier in their applications as the backend.

This is really big revolution in the IT sector especially when we are talking about the job market, MySQL has yielded several jobs in the market for MySQL database administration and application developers.

My solute! To the people, whoever behind the making of MySQL database system.