oleDbConnection with DSN less connection string?

Discussion in 'ASP .Net Web Controls' started by Michael Appelmans, Jun 4, 2004.

  1. When I use the Server Explorer to create a local connection to an Access
    mdb file I wind up with this long winded connection string that has the
    absolute path hard coded. Which makes it difficult to push up to my
    remote web host. My access database is in a data folder inside my
    webroot dir in both local and remote cases, but the absolute path to my
    webroot is different on remote.

    Is there anyway to have the connection string created with
    Server.MapPath? Since the connection string is initialized inside a
    "don't touch" region I can't really modify it there. it would be nice to
    have a way around this absolute path.

    Thanks for any suggestions.

    Michael
     
    Michael Appelmans, Jun 4, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gameface

    ASP Dsn-less connection error

    Gameface, May 3, 2004, in forum: ASP General
    Replies:
    2
    Views:
    165
    Ray at
    May 3, 2004
  2. shank

    SQL and DSN-Less connection

    shank, Jul 21, 2004, in forum: ASP General
    Replies:
    1
    Views:
    160
    Aaron [SQL Server MVP]
    Jul 21, 2004
  3. shank

    dsn less syntax

    shank, Aug 2, 2004, in forum: ASP General
    Replies:
    1
    Views:
    208
    Aaron [SQL Server MVP]
    Aug 2, 2004
  4. A P
    Replies:
    1
    Views:
    249
    Joker
    Sep 29, 2004
  5. Rob Meade
    Replies:
    7
    Views:
    255
    Lance Wynn
    Jan 2, 2005
  6. Arpan

    System DSN Faster Than File DSN!

    Arpan, Jun 26, 2005, in forum: ASP General
    Replies:
    7
    Views:
    511
  7. SIMON GARE

    DSN-Less Connection Help

    SIMON GARE, Mar 10, 2006, in forum: ASP General
    Replies:
    1
    Views:
    208
    Bob Barrows [MVP]
    Mar 10, 2006
  8. Al Reynolds
    Replies:
    4
    Views:
    443
    Al Reynolds
    Sep 11, 2003
Loading...