DSN-less Connections & Server.Mappath

Results 1 to 2 of 2

Thread: DSN-less Connections & Server.Mappath

  1. #1
    B.H.Carr Guest

    Default DSN-less Connections & Server.Mappath

    The Web Weekly mailing dated 6/23/99 talks about DSN-less connections, and the inefficiency of Server.Mappath.<BR><BR>I use DSN-less connections to save $35.00 per System DSN.<BR><BR>Will my efficiency increase if I use Server.Mappath during development to find the correct path, then replace Server.Mappath with the resulting database path it has provided?<BR><BR>For example, start with:<BR>connpath = "DBQ=" & server.mappath("database.mdb")<BR><BR>Display the result of connpath to get the DBQ path:<BR>&#060;%= connpath &#037;&#062;<BR><BR>Then, replace the original code with the resulting path:<BR>connpath = "DBQ=D:pathpathdatabase.mdb"<BR><BR>B.H.Carr<BR>bc arr@bcarr.com<BR>www.bcarr.com

  2. #2
    Join Date
    Dec 1969

    Default RE: DSN-less Connections & Server.Mappath

    Yes, do that!! :) There are DSN/DSN-less performance issues, but I have been informed that they were resolved with recent versions of ODBC/ADO.<BR><BR>So, still, refrain from using Server.MapPath if you can. Use it once to get the path, then hard code that sucker! :)

Posting Permissions

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