Advice for Intranet Based Application

Posted on 2011-10-03
Last Modified: 2012-08-13

We used to have our local software's running in MS Access, but lately we are facing alot of errors.

Now we are thinking of shifting to some other language. Can you please guide me which language can we go for. We are thinking of going for Intranet based applications now.

Please suggest me the front-end as well as database option we can go for. We are currently running windows server 2003.

Thanks :)
Question by:Rahul Sehrawat
    LVL 15

    Expert Comment

    It is very depends on your needs.

    Do you really need/want to access the system from the web? this can open your system to hackers if not doing it right and make your data public. are you willing to take the risks?

    you can built interface to use your existing database but I would recommend moving to more advanced database like Microsoft Sql(they have also express version that is free) or even to MySQL

    Author Comment

    by:Rahul Sehrawat

    Thanks for the reply. Actually our server is locally deployed. It cannot be accessed by Public, only people in the LAN have the access to server.

    I was thinking of deploying mySQL as the database. But I am not sure of the front end.

    LVL 15

    Expert Comment

    as you probably know by now is that every development language has it's pros. and cons.

    what i have tried to tell you is that web application are less secured than desktop applications.

    PHP will be the cheapest. and works perfectly with MySQL.
    if you decide on web I will recommend doing it in MVC pattern

    Author Comment

    by:Rahul Sehrawat
    Hi Again,

    I am sorry to bug you with so many questions.

    What database would work great with the following languages, Also what would we have to install  on our windows 2003 server to run web based applications made on these languages:


    Thanks and Sorry .. :(
    LVL 15

    Expert Comment

    It's OK, I'm here exactly for that :)

    ASP is script language like PHP (No need to compile things) the web server works harder. for this language it will be hard to find good programmers (old language)

    ASP.NET is much more powerful then ASP but it needs to be compiled in advance. I personally use this language combined with c#(C Sharp)

    Java is not Microsoft product, I didn't worked with it so I can't say anything about it (I'm more a MS guy)

    Author Comment

    by:Rahul Sehrawat
    ahh thanks for the suggestion..

    so what I am telling my office people is we can go for the following:

    PHP with mySQL
    ASP.NET  with Microsoft SQL (Express Version)

    I will do little bit search on JAVA too. and I hope this will not cost anything except the developer cost to our company.
    LVL 15

    Accepted Solution

    that sums it up well :)

    Microsoft SQL (Express Version) size is limited to 10GB but if you have access now it will be ok because access limits are lower

    Author Closing Comment

    by:Rahul Sehrawat
    Thanks alot or the suggestion.. :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now