A real new beginer !

Results 1 to 3 of 3

Thread: A real new beginer !

  1. #1
    Join Date
    Dec 1969
    Posts
    118

    Default A real new beginer !

    Well, I work with Frontpage. I have a database in the dir "c:websharewwwrootrucefpdb\" named "mp3db.mdb". I&#039ve added this DB in ODBC as a system DNS. I made an global.asa file that look like that :<BR><BR>&#060;script language="vbscript" runat="server"&#062;<BR> Sub Session_OnStart<BR> Dim objConn<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.ConnectionString = "DSN=mp3db"<BR> objConn.Open<BR> End Sub<BR>&#060;/script&#062;<BR><BR>Then, here is the "larchive.asp" file :<BR><BR>&#060;%<BR> Dim objRS<BR> Set objRS = Server.CreateObject("ADODB.Recordset")<BR> <BR> Dim strSQL<BR> strSQL = "SELECT * FROM Song"<BR> <BR> objRS.Open strSQL, objConn<BR>%&#062;<BR>&#060;html&#062;<BR><BR>&#06 0;head&#062;<BR>&#060;title&#062;L&#039archive&#06 0;/title&#062;<BR>&#060;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&#062;<BR>&#060;meta name="GENERATOR" content="Microsoft FrontPage 4.0"&#062;<BR>&#060;meta name="ProgId" content="FrontPage.Editor.Document"&#062;<BR>&#060 ;style type="text/css"&#062;<BR>&#060;!--<BR>A:link{text-decoration: none; color: #FFFF00;}<BR>A:visited{text-decoration: none; color: #FFFF00;}<BR>A:active{text-decoration: none; color: #FFFF00;}<BR>A:hover{text-decoration: none; color: #00ff00;}<BR>--&#062;<BR>&#060;/style&#062;<BR>&#060;meta name="Microsoft Border" content="b, default"&#062;<BR>&#060;/head&#062;<BR><BR>&#060;body background="images/fond.gif" bgproperties="fixed" bgcolor="#000000" text="#FF0000"&#062;<BR><BR>&#060;div align="center"&#062;<BR> &#060;center&#062;<BR> &#060;table border="0" cellpadding="0" cellspacing="0" width="95%"&#062;<BR> &#060;tr&#062;<BR> &#060;td width="100%"&#062;<BR> &#060;p align="center"&#062;&#060;font face="Arial" size="7" color="#008080"&#062;&#060;strong&#062;&#060;em&#0 62;L&#039ARCHIVE&#060;/em&#062;&#060;/strong&#062;&#060;/font&#062;&#060;/p&#062;<BR> &#060;div align="center"&#062;<BR> &#060;center&#062;<BR> &#060;table border="1" width="50%"&#062;<BR> &#060;tr&#062;<BR> &#060;td width="20%"&#062;Titre&#060;/td&#062;<BR> &#060;td width="20%"&#062;Artiste&#060;/td&#062;<BR> &#060;td width="20%"&#062;Album&#060;/td&#062;<BR> &#060;td width="20%"&#062;Genre&#060;/td&#062;<BR> &#060;td width="20%"&#062;D├ębit&#060;/td&#062;<BR> &#060;/tr&#062;<BR> &#060;% Do Until objRS.EOF = True %&#062;<BR> &#060;tr&#062;<BR> &#060;td width="20%"&#062;&#060;% =objRS("Songtitle") %&#062;&#060;/td&#062;<BR> &#060;td width="20%"&#062;&#060;% =objRS("Songartist") %&#062;&#060;/td&#062;<BR> &#060;td width="20%"&#062;&#060;% =objRS("Songalbum") %&#062;&#060;/td&#062;<BR> &#060;td width="20%"&#062;&#060;% =objRS("Songgenre") %&#062;&#060;/td&#062;<BR> &#060;td width="20%"&#062;&#060;% =objRS("Songbitrate") %&#062;&#060;/td&#062;<BR> &#060;/tr&#062;<BR> &#060;% objRS.MoveNext %&#062;<BR> &#060;% Loop %&#062;<BR> &#060;/table&#062;<BR> &#060;/center&#062;<BR> &#060;/div&#062;<BR> &#060;/td&#062;<BR> &#060;/tr&#062;<BR> &#060;/table&#062;<BR> &#060;/center&#062;<BR>&#060;/div&#062;<BR>&nbsp;&#060;/body&#062;<BR><BR>&#060;/html&#062;<BR><BR>I&#039ve got a personnal web server running.<BR><BR>In Frontpage, I&#039ve settle my website dir to be able to execute scripts or programs, I also did it for the fpdb dir (where my database is).<BR><BR>Then, in my browser, I type :<BR><BR>"http://bruce/larchive.asp"<BR><BR>Usualy, if I do the same for an html file, this file is loaded. But, with the asp file my browser (IE5) ask me if I want to download the asp file !<BR><BR>What&#039s wrong ? Please help !

  2. #2
    Volker Guest

    Default RE: A real new beginer !

    you probably forgot to install the asp component for your PWS<BR>(there must be an asp.dll on your webserver)

  3. #3
    Join Date
    Dec 1969
    Posts
    118

    Default RE: A real new beginer !

    Thank you ! That was it !<BR><BR>So, now I can continue my work !<BR><BR>Come to see my website, there will be a great asp page very soon !<BR><BR>A+++<BR>Bruce<BR>http://www.bheller.com

Posting Permissions

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