Results 1 to 3 of 3

Thread: RE: Server Mappath in Connection string for Access

  1. #1

    Thread Starter
    Fanatic Member kaihirst's Avatar
    Join Date
    Jul 2005
    Location
    The Resaurant At the End of The Universe
    Posts
    633

    RE: Server Mappath in Connection string for Access

    Hi

    Can and has anybody used a server.mappath to map an access database and use this method within a connection string?

    got a pretty good idea, and it goes something like this.


    VB Code:
    1. Driver={Microsoft Access Driver (*.mdb)};" & _
    2. "Dbq=" & server.MapPath("http://path") & _
    3. "Uid=HELLO;Pwd=WORLD;"

    am I correct? or does this need correcting...

    Cheers all

    Kai
    As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..

    A few things that make a good Developer a Great One.
    Methodical and a thorough approach to research and design inevitably leads to success.
    Forward thinking is the key to Flow of control.
    Never test in the design environment, always test in real time, you get the REAL results.
    CBSE & OOSE are the same animal, they just require different techniques, and thinking.
    SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
    The key to good design is explicit attention to both detail and response.
    Think Freely out of the "Box" you're in..... You will soar to better heights.

    Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT


  2. #2
    PowerPoster
    Join Date
    May 2006
    Posts
    2,988

    Re: Server Mappath in Connection string for Access

    Server.Mappath returns a physical path on the server, so that wont work.

  3. #3
    Hyperactive Member gtilles's Avatar
    Join Date
    Dec 2004
    Location
    Planet Earth
    Posts
    394

    Re: Server Mappath in Connection string for Access

    server.MapPath("accessdb.mdb")

    Is what I use....
    Truly, you have a dizzying intellect.

Posting Permissions

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



Click Here to Expand Forum to Full Width