Where is the database connection?

Results 1 to 3 of 3

Thread: Where is the database connection?

  1. #1
    Ted Samuels Guest

    Default Where is the database connection?

    If you go to just about any E-commerece web site and view their source code for a form, or price list on their products, you can never see the database connection. No SQL...No ADODB... No DBQ etc, So how do they post their products information to the web page? There must be a database somewhere in the background.<BR> <BR>Please shed some light on me!!!

  2. #2
    anonymous Guest

    Default RE: Where is the database connection?

    The database code exists, it&#039s just that the code will be run at the server side and the server will return the results as HTML to the browser.

  3. #3
    Join Date
    Dec 1969

    Default RE: the server parses out that information

    normally the connection is referenced between the asp delimiters like this <BR><BR>&#060;% <BR>Session("DatabasePath") = "C:Websxtzdataprivatecustomerinfo.mdb"<BR><BR> Set DataConnection = Server.CreateObject("ADODB.Connection")<BR>DataCon nection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Session("DatabasePath") & ";"<BR><BR>Set cmdDC = Server.CreateObject("ADODB.Command")<BR>cmdDC.Acti veConnection = DataConnection<BR>SQL = "SELECT * FROM customersprivateinfo"<BR><BR>cmdDC.CommandText = SQL<BR>Set RecordSet = Server.CreateObject("ADODB.Recordset")<BR><BR>%&#0 62;<BR><BR>as you see all this information is between the delimiters. that information is parsed out by the server and not returned to the html page.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts