Re: Relational Databases

Another way to go is ASP. If you have any knowledge of scripting you will
find ASP really easy to use. For example here is all the code you need to
access a databasecreate a record set in ASP!

 strConnect="Driver={Microsoft Access driver
(*.mdb)};DBQ=c:\primahealth\somedb.mdb"

'create a connection object
  set oConn =Server.CreateObject("ADODB.Connection")
  set oRec =Server.CreateObject("ADODB.recordset")

'open the connection object and create a record set
  oConn.Open strConnect
  oRec.Open "mppassword", oConn, 0,3,2

I agree with Eric  that you should use a SQL backend. Access is not suitable
for heavy duty work, but is great for prototyping.

Another advantage of ASP is that you can do the whole development process on
your desk-top with PWS and Access before porting to a server and SQL.
Further more there is great documentation available for ASP. i would
recommend Beginning ActiveServer Pages from Wrox Press.

Frank
----- Original Message -----
From: Eric J Hoffman <ehoffman(at)smalldogdesign.com>
To: Ben Ocean <beno(at)cnw.com>; <hwg-techniques(at)mail.hwg.org>
Sent: Wednesday, April 05, 2000 7:27 PM
Subject: RE: Relational Databases


> Cold Fusion is one way to get that done; check out www.autobytel.com...it
is
> all done in Cold Fusion....  If it is highly trafficked, I would suggest a
> SQL backend as access tends to fry under a moderate load.  Cold Fusion is
I
> think easier to learn as it is tag based like HTML....please send any
> questions my way!
>
> Eric J Hoffman, MAIP
> Director of Internet Development
> Small Dog Design
>
> -----Original Message-----
> From: owner-hwg-techniques(at)hwg.org
> [mailto:owner-hwg-techniques(at)hwg.org]On Behalf Of Ben Ocean
> Sent: Wednesday, April 05, 2000 2:57 PM
> To: hwg-techniques(at)mail.hwg.org
> Subject: Relational Databases
>
>
> Hi all;
> I've bitten off more than I can chew, and although it may cause
> indigestion, this one's going down :) I've signed a deal with a car
> dealership to develop a web site using a searchable, relational database
> that dynamically generates web pages from the server: one that can be
> completely rebuilt with new data by simply updating the server through MS
> Access or what have you.
>
> I'm new to *all* of this (but a very fast study). What approach would be
> optimal? ASP? Java? JavaScript? What resources (like this one) specific to
> that language do you recommend? What programs? I'd rather avoid CGI since
> it's too technical for me, but I guess I could job that out if I had to.
> Your suggestions, please! TIA,
> BenO
>
>

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