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,444
    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.
    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,468
    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 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 19:48.
    hope this help

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

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