Database & asp:compare asp to

Results 1 to 2 of 2

Thread: Database & asp:compare asp to

  1. #1
    Join Date
    Dec 1969

    Default Database & asp:compare asp to

    Hello.<BR>In the following lines you see the strconnect,the source of that is arranged according to address of my hard,then it doesn&#039;t work when you upload it to Internet.Could you change the line in a way that I can upload it to Internet:<BR>(look at line 4 & 5)My questions are at the bottom of the page.<BR><BR>&#060;html&#062;<BR>&#060;body&#062;< BR>&#060;%<BR>strconnect="provider=microsoft.jet.o ledb.4.0;data source=C:InetpubwwwrootDirectors.mdb"<BR>set objcon=server.createobject("ADODB.Connection")<BR> set objrs=server.createobject("ADODB.recordset")<BR>ob strconnect<BR> "Directors1" , objcon<BR>While not objrs.EOF<BR>Response.write objrs("SerialNo") & " "<BR>Response.write objrs("DirectorName") & " "<BR>Response.write objrs("FilmName") & " "<BR>Response.write objrs("ActorName") & " "<BR>Response.write objrs("ActoressName") & " "<BR>Response.write objrs("DateOfProduction") & " "<BR>Response.write objrs("DateOfDisply") & " "<BR>Response.write objrs("Budget") & "<BR>"<BR>objrs.movenext<BR>wend<BR>objrs.close<BR >objcon.close<BR>set objrs=nothing<BR>set objcon=nothing<BR>%&#062;<BR>&#060;/body&#062;<BR>&#060;/html&#062;<BR><BR>Questions:<BR>1.Now re-write this line in a way that I can upload it to Internet:<BR>strconnect="provider=microsoft.jet.ol edb.4.0;data source=C:InetpubwwwrootDirectors.mdb"<BR><BR>2.Can we apply these codes to<BR><BR>Best Regards<BR>Reza Saheban

  2. #2
    Join Date
    Dec 1969

    Default RE: Database & asp:compare asp to

    1. Do not hardcode the paths. Instead use App.Path variable.<BR>2. Be sure that the ISP provides necessary Database access help.<BR>

Posting Permissions

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