Hi

Whats the best to use for creating the interface for my db (SQL Server 2000). Been thinking of either ASP or ASP.Net.....whats the difference. Which is easier to learn because I going got 1 month


Thanks

ASP "dot Net" is the latest incarnation dreamed up by the Microsoft Marketing Department, so you should Use That.

Until next year of course, when all that will be passe and "obsolete" and Marketing will have something altogether "new!!!" for you to buy.

Seriously, there simply isn't much technically different. Technology is slow and expensive to change; monikers are not. And if you really "only have 1 month" to get some project done, I seriously suggest that you should spend the month finding something suitable that you can buy (and possibly adapt) rather than build.

Actum Ne Agas -- "Do not do a thing already done."

I'd vote for classic ASP as having a much quicker learning curve and less expensive software required to write code in it (any old code editor will do).

And here is something I put together about ASP that hopefully might help somehow.

You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 operating system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/...bscripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an example

Thanks for your reply.

Is there any way of using ASP with a Windows XP home operating system??

Thanks

ASP FAQS : Getting Started : Question: How can I install Personal Web Server (PWS) onto Windows XP Home edition? by Scott Mitchell - 1/10/2002
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=180
"Spoke to David Berry, a Microsoft MVP, who told me 'Microsoft PWS is officially dead...Microsoft decided to discontinue it in favor of supporting IIS. XP [Home] owners will need to upgrade to XP Pro to use IIS.'"
"Of course 2000 or XP Pro is what developers should be developing on, but to cut off the amateur ASP developer seems spiteful and ill-conceived."
"It seems to me that the balance has now tipped ever-so-slightly.
-- James Shaw
-- http://CoverYourASP.com"

You may want to look into www.best-machine.com where currently for $4.50/mo total you can set up 5 domains (i.e. separate Web sites).

Thus you could practice on there.

And regarding FTP here's an interesting link:

www.webdrive.com