p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: ASP/ADO Implementation Issues


Message #1 by "Ray Murphy" <raymondmurphy@c...> on Tue, 4 Jul 2000 22:45:38
I am currently looking into the possibility of web-enabling some of our

existing databases, and possibly providing public Internet access to 

theese

databases (or maybe a copy of these databases). The stage I am at is in

deciding whether to try and do this in-house, or to out-source the 

required

work.



I have a reasonable understanding of ASP/ADO as applied to the development 

of LOCAL 'test' applications on my development platform, but would like to

ask what may be a basic question regarding the deployment and 

implementaion

of ASP/ADO applications.



For the relevant databases, is the following scenario possible :



   a) Relevant database and web server software sits on

      dedicated server machine, with IIS, ASP , ADO, ODBC

      all present on the server ; 



   b) Server machine has mixture of HTML/ASP pages which

      carry out the ASP-ADO specifics of connecting to 

      the database and retrieving the database data ;



   c) Potential users out in cyberspace fire up their   

      web browser, point their browser to the web site

      on our dedicated server, access the pages on our

      dedicated server and finally have the data    

      displayed in their own browser window ;



I suppose my main question is the above scenario feasible WITHOUT the

public's client machines having any ODBC software/drivers installed ?





Thanks.



Ray

Message #2 by "Ken Schaefer" <ken.s@a...> on Wed, 5 Jul 2000 18:10:54 +1000
Ray,



What you describe is entirely possible - in fact most database driven

websites do exactly what you are describing (eg look at www.dell.com,

www.gw2k.com etc).



You retrieve information from a database and merge the results into a

webpage. All that is sent to the client is stock standard HTML.



Cheers

Ken



----- Original Message -----

From: "Ray Murphy" 

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, July 04, 2000 10:45 PM

Subject: [asp_databases] ASP/ADO Implementation Issues





> I am currently looking into the possibility of web-enabling some of our

> existing databases, and possibly providing public Internet access to

> theese

> databases (or maybe a copy of these databases). The stage I am at is in

> deciding whether to try and do this in-house, or to out-source the

> required

> work.

>

> I have a reasonable understanding of ASP/ADO as applied to the development

> of LOCAL 'test' applications on my development platform, but would like to

> ask what may be a basic question regarding the deployment and

> implementaion

> of ASP/ADO applications.

>

> For the relevant databases, is the following scenario possible :

>

>    a) Relevant database and web server software sits on

>       dedicated server machine, with IIS, ASP , ADO, ODBC

>       all present on the server ;

>

>    b) Server machine has mixture of HTML/ASP pages which

>       carry out the ASP-ADO specifics of connecting to

>       the database and retrieving the database data ;

>

>    c) Potential users out in cyberspace fire up their

>       web browser, point their browser to the web site

>       on our dedicated server, access the pages on our

>       dedicated server and finally have the data

>       displayed in their own browser window ;

>

> I suppose my main question is the above scenario feasible WITHOUT the

> public's client machines having any ODBC software/drivers installed ?

>

>

> Thanks.

>

> Ray

>

Message #3 by "Mark Morgan" <mark.morgan@v...> on Wed, 5 Jul 2000 09:16:52 +0100
Ray,

	The ASP code runs on the server and uses ODBC on the server to connect to

the databases, so the client does not need the required ODBC drivers

installed, it's that thin client concept, Magic!



Mark.



-----Original Message-----

From: Ray Murphy 

Sent: 04 July 2000 22:46

To: ASP Databases

Subject: [asp_databases] ASP/ADO Implementation Issues





I am currently looking into the possibility of web-enabling some of our

existing databases, and possibly providing public Internet access to

theese

databases (or maybe a copy of these databases). The stage I am at is in

deciding whether to try and do this in-house, or to out-source the

required

work.



I have a reasonable understanding of ASP/ADO as applied to the development

of LOCAL 'test' applications on my development platform, but would like to

ask what may be a basic question regarding the deployment and

implementaion

of ASP/ADO applications.



For the relevant databases, is the following scenario possible :



   a) Relevant database and web server software sits on

      dedicated server machine, with IIS, ASP , ADO, ODBC

      all present on the server ;



   b) Server machine has mixture of HTML/ASP pages which

      carry out the ASP-ADO specifics of connecting to

      the database and retrieving the database data ;



   c) Potential users out in cyberspace fire up their

      web browser, point their browser to the web site

      on our dedicated server, access the pages on our

      dedicated server and finally have the data

      displayed in their own browser window ;



I suppose my main question is the above scenario feasible WITHOUT the

public's client machines having any ODBC software/drivers installed ?





Thanks.



Ray




  Return to Index