Solved

What is the most effective database/language/webserver for a win2003 server.

Posted on 2004-08-08
8
360 Views
Last Modified: 2010-04-20
Hi,
I have a Win 2003 as a webserver. Not the best hardware. Currently I'm running IIS6 with .Net support, but i'm not using it. I'm running plain html. I'm getting around 1,000 hits a day (on the front page). Mostly from the local intranet, but the machine still gets hits from outside.

I am considering the introduction of dynamic content on my index page and other pages, for that, I need to chose the database, language, and webserver.

The easiest solution is to use Access/ASP-ASP.Net/IIS6, but I doubt that Access can handle that load, unless someone out there has tried it.

I'd really like to use the IIS server installed, because it saves setting up a complex system that no one knows how to replicate except me, which I want to avoid.

Would MySQL work with ASP? That would be cool. If not, PHP maybe.

Finally, MSSQL, which is not free, and I have no idea of the cost.

This is an open discussion, I'll be giving 100 points for the best five answers.
0
Comment
Question by:kalmen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Assisted Solution

by:harry_hendrata
harry_hendrata earned 150 total points
ID: 11746654
Hi there...

I think it more depend on what your expertise.. there are several solutions on this:
1. mySQL/ODBC (http://www.mysql.com/products/connector/odbc/)
2. PHP+adodb (http://adodb.sourceforge.net/)
3. IIS+tomcat+jdbc

regards

harry
0
 
LVL 9

Assisted Solution

by:ronan_40060
ronan_40060 earned 150 total points
ID: 11748659
Hello Kalmen
Well if you want the cost reducing factors
then PHP /Perl would do the trick for you.
1> PHP works well with MySQL database. with IIS or Apache again which is free and widely used web server
2> Perl is also another powerful web scripting language with lot of support for MySQL , MS SQL Server ,Oracle through DBI modules and confifured with Apache and IIS also
3> Also You can use ASP with MySQL or ADO with IIS as default web server.
4> Yes Access 2000 can be used with ASP.NET
also have a look  on this http://www.mysql.com/articles/dotnet/index.html  *** about using dotnet with MySQL ***
good Luck
Ronan
0
 
LVL 34

Accepted Solution

by:
Dave_Dietz earned 200 total points
ID: 11749591
I have seen several setups using IIS 6/ASP(.Net)/mySQL and they work well,  The cost is nothing more than the OS licensing and ASP(.Net) is designed to work work had in hand with IIS.  Anything else like PHP or Perl, while good systems in their own right, are not natively supported in IIS and will add some overhead that I wouldn't normally worry about except that you mentioned your hardware is not the best.

Stay away from Access with IIS at all costs.  While many improvements have been made in recent years Access is not designed for mulitple concurrent users and can run into problems when being used in that role.

MS SQL Server is a great product and may well be able to out scale mySQL in larger environments (not sure it can, but I believe so) the licensing cost takes it out of consideration.  (If you had the money to license SQL Server for this application I doubt you'd have any problem getting a better server to run the whole shebang on as well....)

Dave Dietz
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 9

Expert Comment

by:ronan_40060
ID: 11750557
Hello Dave
Yes I agree with you that Access is not meant for handling large transactions and multiple users.
I have been using Oracle lately and its one of the best database tools used for large databases and users like MS SQL server but yes the problem of cost definitely comes into picture in selecting either MS SQL server or Oracle.
So looking into your overall possibilities
the best solution for cost effective method is to use ASP.NET with IIS and MySQL as database .
 
0
 
LVL 1

Author Comment

by:kalmen
ID: 11751258
I agree with you all. MySQL with ASP.Net and IIS seems sweet. I'm installing it on a test environment, and I just want to check what kind of problems (if any, or none) may occur. I need to write a full documentation for this.
I'll give it a try, if all is okay, I close this and distribute the wealth.

Thanks all, you've been great!
0
 
LVL 3

Expert Comment

by:harry_hendrata
ID: 11752829
Hi Kalmen,

there is one interesting link coming from microsoft on this..
http://www.microsoft.com/technet/itsolutions/migration/linux/mvc/miglamp.mspx

and another one from devshed
http://www.devarticles.com/c/a/ASP/Using-MyODBC-To-Access-Your-MySQL-Database-Via-ASP/

hope this would help
0
 
LVL 9

Expert Comment

by:ronan_40060
ID: 11752978
hello Harry
your links are good
Indeed we need to have connection to be estalblished with MySQL and ASP.NET as its the latest technology to ASP with IIS 6 as web server as I already mentioned the info is available about MYSQL and ASP.NET  at
 http://www.mysql.com/articles/dotnet/index.html
ronan
0
 
LVL 1

Author Comment

by:kalmen
ID: 11771436
Thanks for all your help guys...
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question