Reading the helps, I've learnt that I need a sql server to execute my sql coding, won't that already be avaliable from me installing the iis software.

And plus, am really confused with all these sql server, iis, and server thing. can someone please clarify what the diffrences are, are they all the same thing. I don't even quite know what a server is, and how on earth do i get one. Please please help !!!. (Confused)

Thanks in advance.


You have three different products here.

Windows 2000/2003 Server: this is an operating system that runs on the hardware, and it is optimized to provide server services... meaning it is designed to not have someone sitting in front of the computer using it, rather it is optimized to favor the information sent on the network cards, and manage the information to the hard drives.

IIS: Internet Information Services -- the web and ftp services that can be installed onto Windows 2000 / 2003 server. I do not think IIS can be installed onto XP or 2000 Pro. IIS is needed to do a bunch of things with the server using common internet protocols, but IIS is also a large and processor-expensive package.

SQL: This is a service that process the SQL commands received on the network card. It doesn't necessairly need IIS if you are working outside of Windows. You can make a SQL server out of Linux, and use MySQL to process your commands.

I do not think MSSQL is free. MySQL certainly is, and you can run it from Windows.


Indeed IIS can be installed on both Windows XP Pro and Windows 2000 Pro (but NOT on Windows XP Home Edition).

If you need to execute SQL queries on your home computer (and you have XP pro or 2000) the easiest way is to install IIS (Control Panel -> Add/Remove Programs -> Add/Remove Windows Components -> Internet Information Services). Then download and install the MySQL 4.0/4.1 windows installation and the MySQL ODBC 3.51 Connector from

Then you're good to go.

Thanks peeps, all clear now.