Using an ODBC connection to query your MySQL database remotely can be quite useful for using third party database management softwares (like Microsoft Access) or reporting tools (like Crystal Reports).
But what exactly is ODBC?
ODBC is an abbreviation for Open Database Connectivity. It is an interface used to access databases using SQL queries (Structured Query Language).

This is finally the last post of this series on How To Install Your Own Web Server. In my last post I’ve shown you how to setup a virtual host and now we’re going to use this to install phpMyAdmin.
Of course, the purpose of this tutorial is not really to install phpMyAdmin but it’s rather [...]

In my last post of this series, I’ve shown you how to create a MySQL database using the GUI tools. In the fifth part of this tutorial, we’re now going to see how to add a virtual host.
What Is A Virtual Host?
A virtual host allows your web server to serve multiple websites from a unique [...]

Unfortunately I haven’t seen any good web hosting control panel for Apache on Windows (if you know some, leave a comment!). So that’s why we’re going to need something else to manage the MySQL server.
MySQL provides a set of GUI tools that allows you to perform such tasks as managing databases, managing database users, configuring [...]

In the third part of this tutorial, we’re now going to install PHP 5 on Windows.
In the two previous posts, we’ve seen how to install Apache and MySQL on a Windows computer so you you should already have a working web server and database server.

This is the second part of our tutorial on how to install your own home web server. In the first, you’ve seen how to install Apache HTTP Server on Windows. Now we’re going to see how to install MySQL, a free database server.
MySQL comes in two flavors: Enterprise Edition and the MySQL Community Server. Of [...]

Sometimes I like to have my own web server, whether it is for testing or development purposes. Since I use Windows XP or Vista on my personnal computer, my favorite setup is Windows, Apache, PHP and MySQL. This setup is also known as WAMP. And maybe you guessed it, the Linux equivalent of this setup [...]

I just got this email in my mailbox and I figured it could be useful to other people, so I decided to answer it here. Here it goes:
Hello Stephane
Thanks for the offer.
What I am trying to do is this:
I got a new win 2008 server, and am trying to install different services on it. I [...]

Lately I’ve made a post on how to install MySQL on Windows 2008. I’ve decided to turn it into a video so it would be easier to see how it’s done.
Installing MySQL on Windows 2008 is pretty much the same as with any other versions of Windows so you can apply this to Windows 2003, [...]

It seems some people were a bit confused when it came to installing PHP5 on Windows Server 2008 using FastCGI. So to make things clearer, I’ve made a little video to show you how I’ve done it.
Take note that this WILL NOT WORK on other versions of Windows than this one.

I hope this will help [...]