Dynamic Database Connection

Results 1 to 2 of 2

Thread: Dynamic Database Connection

  1. #1
    Join Date
    Dec 1969

    Default Dynamic Database Connection

    OK.....I&#039;m using VS.Net and I&#039;m trying to create a database connection. In ASP 3.0, I&#039;d simply create an application variable in the global.asa and set it to "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/database.mdb". This doesn&#039;t seem to work.<BR><BR>I&#039;ve tried changing the provider to Microsoft.Jet.OLEDB.4.0 and I&#039;ve even tried using a Server.MapPath("fpdb/database.mdb"). No luck there, either.<BR><BR>I know I can set a key in the appSettings of the Web.config file, but I want it to happen dynamically, as my ISP is going to have a different physical location for the file.<BR><BR>Any ideas about how to set the source of the database without specifying the physical location and without setting up a DSN?

  2. #2
    Join Date
    Dec 1969

    Default RE: Dynamic Database Connection

    I think you will find you need the full URL

Posting Permissions

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