DB Connection

Results 1 to 2 of 2

Thread: DB Connection

  1. #1
    Big Al Guest

    Default DB Connection

    How do you change the DNS less conection from an exat path <BR><BR>e.g.<BR>DBcon = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:windowsdesktopweb_productsFAQdataba seclassified.mdb"<BR><BR>to a DNS less conection were I don&#039;t have to specify the exact path??

  2. #2
    Sven Cipido Guest

    Default RE: DB Connection

    Hi,<BR><BR>You can use following statement :<BR><BR>sConnection = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("FAQdatabaseclassified.mdb") & ";"<BR><BR>But for this, the db must be placed on your webserver in the directory&#039;s Faq/database<BR><BR>Hope this helps you out<BR><BR>Sven C.<BR>

Posting Permissions

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