[thelist] testing/learning SQL and ASP environment

Joel Morris joelm at citycent.com
Tue Sep 25 18:09:44 CDT 2001


I wouldn't be too afraid about breaking anything on the SQL Server.
For learning purposes, just set up a couple of tables on the SQL
Server and then start addressing them from your ASP pages.

You could also use the "Northwinds" database which comes installed by
default on SQL Server.

The books I read originally were:

Teach Yourself Active Server Pages in 24 Hours - Sams (fair intro to
ASP)
Beginning ASP Databases - Wrox (excellent book)

It's also really handy to have a copy of O'Reilly's Nutshell books:

ASP In A Nutshell
VBScript In A Nutshell

I do all of my development with remote databases, write my scripts and
then FTP them up to the appropriate server and test them out. That way
I know my scripts will really work in the production environment.

Good luck!

Best, Joel Morris
-------------------------------
CityCenter Co.
Website Development & Marketing
http://www.citycent.com
mailto:joelm at citycent.com


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Rob Oviatt
Sent: Tuesday, September 25, 2001 6:16 AM
To: thelist at lists.evolt.org
Subject: [thelist] testing/learning SQL and ASP environment


I've got to learn SQL and ASP for work, and am wondering what is the
best
way to set myself up to do so.  I've got our web server (NT4, IIS 4
w/sp6,
MS SQL 7.0), and a Win98 system on my desk at work, and a Win 98
system at
home.  I'd like to be able to work on this from both home and work,
but
don't want to risk (through my inexperience) damaging or breaking the
SQL
interactions already occurring on our server.  Which were created and
maintained by an outside service.

Questions:

1. Is there a package or group of programs I can install at home on my
Win98 system to learn/develop/test SQL databases and ASP pages without
having to access our web server?

2. Anyone have some beginner links for running/working with an SQL
server.
I have not previous experience with web database interaction and have
a
basic understanding with Javascript.

3. Recommendations on Beginner book?

There are probably more things I should be asking, but don't know to
ask yet.

Rob Oviatt

Web Developer / Typesetter
Appleby Color Lab
phone: (506) 459-2320
email: applebyweb at nb.aibn.com
web site: http://www.applebycolorlab.com/


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !





More information about the thelist mailing list