Dreamweaver connection no workie

Discussion in 'General troubleshooting' started by mother, Nov 1, 2008.

  1. I have designed a deamweaver shopping cart locally on my server running XP Pro and Access XP and works fine connecting to my local database, however cannot connect to DSP'sDB at _\database\educoncert.mdb. When I try using remote server custom string.

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath[\_database\educoncert.mdb]". Says it's to long

    I tried a simple connection string and it connects but it stops working when I add a form element.

    <%
    Dim cnnSimple ' ADO connection
    Dim rstSimple ' ADO recordset
    Set cnnSimple = Server.CreateObject("ADODB.Connection")
    ' DSNLess
    cnnSimple.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; Server.MapPath("\_database\educoncert.mdb"))
    Set rstSimple = cnnSimple.Execute("SELECT * FROM customers")
    %>

    I just want to use the files from my local work on there sever and help appreciatd.
    is there a workaround or connection string for remote that I can use.
     
  2. Hi,
    Shown below is a Dreamweaver and Access conn string I use for testing on a DASP IIS6 server:
     
  3. Thanks have it working.
     

Share This Page