943,712 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 17265
  • ASP RSS
Jun 1st, 2005
0

Do I really need an sql server

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
nike123 is offline Offline
20 posts
since Jun 2005
Jun 1st, 2005
0

Re: Do I really need an sql server

Hello,

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.

Christian
Team Colleague
Reputation Points: 121
Solved Threads: 57
Posting Virtuoso
kc0arf is offline Offline
1,629 posts
since Mar 2004
Jun 1st, 2005
0

Re: Do I really need an sql server

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 www.mysql.com.

Then you're good to go.
Reputation Points: 10
Solved Threads: 5
Junior Poster
madmital is offline Offline
119 posts
since Jun 2005
Jun 2nd, 2005
0

Re: Do I really need an sql server

Thanks peeps, all clear now.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
nike123 is offline Offline
20 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: ASP Date Help - If Then Else
Next Thread in ASP Forum Timeline: Using CDO in VBS - not working





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC