Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008

    Unanswered: Dreamweaver-ASP-Access 2003 Connection

    I'm trying to connect my Dreamweaver site to an Access 2003 database via ASP. When I test the DSN connection on the test server, I get this error message:

    [Microsoft][ODBC Driver Manager] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by anotehr user, or you need permission to view its data.

    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

    When we set up the DSN connection on the remote server, we pointed it to a .mdb file, which it's apparently not seeing.

    My network manager swears its a problem with Dreamweaver, but I don't even know where to begin troubleshooting.

    Can anyone help?

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Could you post the connectionstring you are using? I suspect you need to use a UNC path but it's hard to troubleshoot given the tiny amount of info provided.
    Home | Blog

  3. #3
    Join Date
    Oct 2004
    I have exactly the same problem, and have reduced the Access-2003 database to its simplest form, with a simple ASP page to display the table contents. I'm using Dreamweaver MX 2004, and have set full permissions for everyone, but it still doesn't work.

    I don't think its an MDAC issue, as I'm using WinXPpro/SP2 which doesn't pemit use of MDAC (as its all apparently included).

    I'm stumped!!

  4. #4
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    What does the Connection string say

    also I could never get ASP (databaseing) and Dreamweaver working

    I just write the code them test it in explorer as if live.
    one thing I do is turn on IIS in XP use that as my testing computer

    I have a

    <!--#include file=""-->
    Dim DB  ,DBPath 
    DBPath = server.mappath("orders\Data.mdb")
    Dim connstring   'conection string
    connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath & ";"
    'RESPONSE.WRITE "** >>>>" & connstring
    I have
    <!--#include file=""-->
    at the top of every page when I want to talk to the database

    Then to write/get data I just do

    SET RS = Server.CreateObject("ADODB.Recordset")

    SQL =""
    SQL = SQL &"SELECT Prod.*"
    SQL = SQL &" FROM Prod "
    SQL = SQL &" WHERE (((Prod.Sheet)='" & whereThis & "'))"
    SQL = SQL &" ORDER BY Prod.Type;"

    now let open it SQL , connstring , adOpenStatic , adLockPessimistic

    the HARDNEST thing to get right is the connection String write
    that I wrote about 5 year ago and all i have to change now is the DBPATH and it works every time

    as long as the database is in the same place as test / live everything should work.
    Last edited by myle; 07-09-08 at 20:48.
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

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