How to connect vb to mysql

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.

WordPress theme – Uploading Problem

How to resolve wordpress uploading problem

Whenever upload a wordpress theme’s zip file to the server, always remember to check that this zip file when you extract contain any folder or no?

For example if you did upload the blossom.2.3.zip file to your blogs themes folder under the wp-content folder and you extract it after uploaded by using the control panel.

I think it is a good idea to first unzip on your computer/PC itself in any folder. If you found the theme named folder in this case should be blossom.

If you found the directory blossom and under it you have all the files, then it is ok. Otherwise in some cases you might have another directory under blossom and no files example blossom_v1-4 etc and under that you will have all the theme files.

In that case you should not upload that zip file, instead you should zip the blossom-v1-4 directory that contains all  the files.

Then upload this new zip file and follow the instructions on this post.

How to Install MySQL

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?

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.

How To Upload WordPress Plugin

To upload WordPress plugin or wp plugin to your WordPress blog. Using control panel

Download the plugin on to your computer or PC. Usually with extension zip
1. Login to your website control panel

http://www.yoursitename.com/cpanel


2. Go to Legacy File Manager or File Manager

3. Go to your WordPress blog’s wp-content directory

4. Go to plugins directory

5. Click on Upload option

6. Click on Browse button

7. Select your computer/pc directory where you have download plugin zip file

8. Click on Open

9. Click on Upload button

10. To refresh the folder content of your wp-plugin directory

11. Click on Directory One level Up (that will take you to the wp-content directory)

12. Click again on wp-plugins directory (now you can see your zip file is sitting there)

13. Click on your plugin zip file link (text link)

14. Right side of the control panel you will have this file name along with some options like copy, move, extract etc.)

15. Click on Extract option( a window will open with shows the extracted files and directories)

16. You are done here, now you can go to your WordPress admin and under the plugins you will   find your new plugin there

17. You can click on the “Activate” plugin option to activate the new plugin.

18. Congrats you just installed and activated a wordpress plugin on your site.

19. Keep coming on this site I will provide you information about good plugins which are worth to have on your wordpress blog.