Hi All,

I am seeking advice on what language to use to build an interface for an upcoming project with a MSSQL backend.

I have been set with the task of re-developing a core database for my employer. The database is currently in Access with a VB interface.

The only guidelines that have been set for the project are that it must utilise MSSQL(They already have the licenses) and must be web-based so it is accessible from our regional offices.

Our network administrators are encouraging me to use ASP.Net as we currently have a pure Microsoft datacenter/network (i am not a fan of running PHP in a windows environment in a production role) although if required, they would give me a linux server.

My background is in PHP although i do have some experience in entry-level ASP.net. and have no doubt with some reading, could build me skill level.

Can anyone share their experience with running PHP & MSSQL or offer me any valid reasons why ASP.Net would be more appropriate for this project.

P.S. I don't want to start an ASP vs PHP war, we've seen it enough already. I am really just after other peoples experiences.

Cheers!

I have never done PHP via MSSQL I guess it’s possible – But my recommendation is to go ASP.NET via MSSQL. If you have a MSSQL Server and a Win2K3 ASP.NET is the way to go. ;)

I don't want to be seen as a careerist hack :-) but you're being handed an opportunity on a plate to increase your skills. I'd definitely go with the ASP.NET solution, even though it may mean more work up front for you.

I propose java :D

It's got all the power of ASP.NET and the portability to run on windows, linux, bsd, solaris etc. so that they are not tied to one system in the future. It's also pretty much free.

Seems like you're already leaning towards ASP.NET you just need that extra push. *push*

I would say go for ASP .NET

I would make a .Net WebService and then a .Net WinForms / Java client depending on end-user OS, if the must be web based part is somewhat negotiable (I don't like ppl working over the browser, despite the fact that win apps are way more powerful). If it's not negociable at all ASP.Net all the way maybe with a flash interface to stop some of the annoying refreshes.

My 2 cents

If you have no experience in real OO programming then I'd stick with PHP, ASP.Net is completely different from the classic ASP VBScript and has a steeper learning curve.

The only time I've used MSSQL was with Cold Fusion and it was mad easy. Much simpler than PHP+MySQL (but also much more expensive).