Cannot link DSN using DreamWeaver

Discussion in 'Databases' started by animekid, Apr 3, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I created a DSN connection from the Control panel

    I am using Dreamweaver to add the DSN connection and am having a LOT
    of problem. Everytime when i do a "Test Connection" to the DSN connection
    i get error msg like "Testing server does not exist" ;
    "Testing Server does not map to the file specified" or
    "Unidentified error"

    What seems to be the problem?

    a) Does it lie in the definition of the testing server? What shld i put
    for the URL prefix?

    b) How shld i specify the path to my database file in the control panel?
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    what version of DW are you using?

    quote:Originally posted by animekid

    I created a DSN connection from the Control panel

    I am using Dreamweaver to add the DSN connection and am having a LOT
    of problem. Everytime when i do a "Test Connection" to the DSN connection
    i get error msg like "Testing server does not exist" ;
    "Testing Server does not map to the file specified" or
    "Unidentified error"

    What seems to be the problem?

    a) Does it lie in the definition of the testing server? What shld i put
    for the URL prefix?

    b) How shld i specify the path to my database file in the control panel?


    </blockquote id="quote"></font id="quote">
     
  3. I have the same problem. I am using Dreamweaver MX. I typed in Custom Connection String:
    "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\web\Username\htdocs\_database\vote.MDB"

    "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/htdocs/_database/vote.MDB"), etc...

    None of them is working, showing the same error messages as previous posting. Please help!
     
  4. Your Dreamweaver site definition and/or testing server configuration is most likely not set up properly. It is probably testing the connection on your local machine.
     
  5. Bruce

    Bruce DiscountASP.NET Staff

    Try

    "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/_database/vote.MDB")

    quote:Originally posted by sofunny

    I have the same problem. I am using Dreamweaver MX. I typed in Custom Connection String:
    "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\web\Username\htdocs\_database\vote.MDB"

    "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/htdocs/_database/vote.MDB"), etc...

    None of them is working, showing the same error messages as previous posting. Please help!
    </blockquote id="quote"></font id="quote">
     
  6. animekid, sofunny:

    What did you do to resolve this problem. I am encountering the same issue. Any help would be appreciated.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page