ADO Error on Network

Results 1 to 2 of 2

Thread: ADO Error on Network

  1. #1
    Vipul Desai Guest

    Default ADO Error on Network

    I am having a problem of using ADO and Access on a network.<BR>When I put my MDB file on my hard drive, I can actually get ASP code to work. But when I put my MDB file on the Network, my code does not work. Can someone please help?<BR><BR>Set ConnTemp = Server.CreateObject("ADODB.Connection") <BR>Set DSNTemp = "Driver={Microsoft Access Driver (*.mdb)}; "<BR> &#039I could Use UNC where the path is: \forest_fmdshareanalyticvipulproj1samples1.mdb <BR><BR>DSNTEMP = DSNTEMP & "DBQ=" & Server.MapPath("Jshareanalyticvipulproj1samples1.m db")<BR>ConnTemp.Open dsntemp<BR> <BR><BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    463

    Default RE: ADO Error on Network

    If you use server.mappath you do not specify the path, just the filename. This is the purpose of the server.mappath method.<BR>For instance <BR>Server.MapPath("myDatabase.mdb")<BR><BR>Here is a link to a page about DSNLess connections, if that is really what you want to use.<BR>http://www.activeserverpages.com/learn/dbopen.asp

Posting Permissions

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