Re: Book on SQLserver and ASP

by "David Clapper" <dclapper(at)clioassociates.com>

 Date:  Fri, 7 Jul 2000 17:26:09 -0400
 To:  "Michelle Brown" <mab(at)OREGON.UOREGON.EDU>,
<hwg-techniques(at)hwg.org>
 References:  bellsouth uoregon
  todo: View Thread, Original
Hi Michelle,

There are a couple of chapters on database techniques in the Wrox "Active
Server Pages" text - these have info on ASP and SQL Server interspersed.  I
can't quite gather how familiar you are with Access and ADO - if you are,
I'd tend to recommend a SQL Server-specific book (I've found the "Inside
Microsoft SQL Server" book handy, as well as the Wrox "ADO Programmer's
Reference".)

I had a situation where I was using ASP with Access and wanted to upscale to
SQL Server.  I had my ISP run the upsizing wizard on the Access database and
went from there.  I don't recall making any significant changes to the
ASP/ADO code (other than changing the OLE/DB provider) - we didn't need to
use any SQL Server-specific features at that point.  It's worked like a
charm since.

Website-wise, I haven't used anything, but if I had a question I'd go to one
of the microsoft.public.sqlserver.* newsgroups

HTH.  Let me know if I can be of more assistance.

David Clapper
Vice-President & Chief Architect
Clio Associates
70 Pavilion St.
Rochester, NY 14620  USA
Voice: +1.716.442.5407
Fax: +1.716.442.5993
Cell: +1.716.259.3699
e-mail: dclapper(at)clioassociates.com
PGP key ID: 0xC67E9E98


----- Original Message -----
From: Michelle Brown <mab(at)OREGON.UOREGON.EDU>
To: <hwg-techniques(at)hwg.org>
Sent: Friday, July 07, 2000 3:11 PM
Subject: Book on SQLserver and ASP


> Hi listfolk:
>
> I hope this is not too off topic.  I will shortly be working with several
> projects that have an online registration component.  We run Windows NT
> here at our office and we have MS SQLserver installed on the server.  [We
> used to use filemaker pro and these kind of things were a breeze... but we
> have since changed camps..  :( ]  I have set up a database in Access with
> the data structure for the event.  Now I just have to do the ASP page,
that
> will capture the data from a webpage and add it into the database.  Of
> course there needs to be some basic data validation (did you enter your
> email address and name, etc) but otherwise this is very straightforward.
>
> I was wondering if anyone had any book or website recommendations that
they
> found especially helpful when interacting with the MS SQLserver and/or
> Active Server Pages.
>
> Thanks in advance for your help!
>
> -Michelle
>
>
>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
> Michelle Brown
> Web Site Specialist
> Student Academic Affairs
> University of Oregon
>
> mab(at)oregon.uoregon.edu
> (541) 346-1172
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA