Avatar of bjones8888
bjones8888
Flag for United States of America asked on

Advice on web application

I have a new application to put together and I need advice.  It requires a sql database and I'd like the user interface to be via a web browser.  I have a lot of experience with sql server and with Delphi 5 in a client server application.

However, for this application I will be using Delphi 2006 Architect.  But I have never built a web application that connects to a remote database.  So I don't know what will be required for the server side or what (if anything) will be required on the client.  Ideally, nothing would be installed on the client.  Just their browser.

Security is important.  There would be users distributed worldwide.  The business logic I can handle.

If someone has a barebones framework that I could expand upon that would be ideal.

Thanks!
Delphi

Avatar of undefined
Last Comment
Wim ten Brink

8/22/2022 - Mon
Wim ten Brink

I would suggest that you start learning ASP.NET combined with Delphi. You would have to use the .NET personality of BDS in that case. This also means you'll need a server with .NET enabled and basically with full ASP.NET support. (Version 1.1 of .NET, btw.) If you have ASP.NET and ADO.NET and SQL Server installed then you should have everything you need.
This also means the client needs to install NOTHING.

It's just that you'll have to start learning ASP.NET and whatever is part of it. O'Reilly publishers have some good books about it.
bjones8888

ASKER
Where do I go to install ASP.NET and ADO.NET on my server?
atul_parmar

I would also suggest ASP.Net and Delphi.Net.

For ASP.Net you would require IIS (Internet Information Server) where you will host your web app. ADO.Net is .Net component for database connectivity and it will be available if .Net is installed on your machine.
Your help has saved me hundreds of hours of internet surfing.
fblack61
bjones8888

ASKER
I have a server with Windows Small Business Server 2003 installed.  Does that include IIS and .Net?  (That's probably a question for a different topic area.)
Wim ten Brink

SBS2003 should include IIS, yes. But it might not be installed by default so you need to install it from the Windows CD-Rom in that case. Also, 2003 might have disabled a few actions by default which you would have to enable in that case. Keep in mind that you'll need to learn to administer this system if you're going to develop software for it. It's not writing the ASP/Delphi.NET code which is the hardest part. It's setting up your IIS box to be secure and stable. If you're a newbie at this then you have a lot to learn here.
Btw, many companies will divide the webserver from the database. Thus, they have two separate machines where one contains the SQL Server database and just that. The other system contains IIS and any web applications and just that. The webserver system would connect to the database system over the internal network. The webserver would also have a secondary network card and connection to connect to the outside world. This way, your database would be secure behind your webserver. It has no need to go on the Internet anyways. :-)

But this all is just proper administration of Window boxes. Not related to Delphi. Writing an ASP.NET application in Delphi is the easy part.
bjones8888

ASKER

Ahhh.  I never understood the reason for separating the database onto a different box, but this makes good sense.  Only the IIS box running the application needs to be able to see the database (so we keep it visible only on the internal network).  That's easily done.

So I have my SBS2003 server running IIS.  I've verified that I have IIS and ASP.NET installed.  I am a newbie regarding IIS, so there'll be a learning curve here.

Initially, during development, it's my SBS2003 system I'll be using.  Later, we can have two "real" servers -- one for the web stuff and the other for the database.

For now, I've got a public/static IP address that points to my router.  Can't I just forward the necessary ports to my SBS2003 box for my web app?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
sun4sunday

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
sun4sunday

Workshop_Alex ,

That was a very long one and give more ideas.
I have to clear something. Is ASP.net applicaitons will run with out framework?
                                      even in windows 98 ?


sun4sunday
bjones8888

ASKER
Thank you all for your time and comments.  It was very helpful.  I was hoping to have some basic code to start off with, but apparently the issues are too varied to have anything meaningful?
atul_parmar

Yes, sun4sunday ASP.net applicaitons can run on windows 95 too.

But the system where it is hosted must have .Net installed.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Wim ten Brink

ASP.NET applications run on the server, sun. So the client still just needs a webbrowser. So the client can use Windows 98, Linux, MAC OS or whatever else they like. It's just that an ASP.NET application might generate some client-side scripting code, depending on the coltrols you use so the client needs to enable JavaScript/ECMAScript/VBScript on their system.