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

    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
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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.
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2004
    Posts
    3
    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
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    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 OpenDB.inc

    Code:
    <!--#include file="adovbs.inc"-->
    <%
    Dim DB  ,DBPath 
    DBPath = server.mappath("orders\Data.mdb")
    'RESPONSE.WRITE DBPATH 
    Dim connstring   'conection string
    connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath & ";"
    'RESPONSE.WRITE "** >>>>" & connstring
    I have
    <!--#include file="OpenDB.inc"-->
    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
    RS.open SQL , connstring , adOpenStatic , adLockPessimistic

    the HARDNEST thing to get right is the connection String write
    that openDB.inc 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
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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