Microsoft ODBC Error - Can It Be Fixed?

Posted on 2012-08-15
Last Modified: 2012-08-17
I am using Dreamweaver 2004 and a Microsoft Access 2007 mdb file to access a table.
I am using a Windows 2008 Server set to use a 32-bit driver.

I set up a database connection on the server using ODBC

Inside Dreamweaver I create an ASP page.

Inside Dreamweaver I set up a Query that uses a select statement with a Datasource name of OpenOrdersCustomers. The Table name is BareDieDataSheets.

Inside Dreamweaver I am able to test the link to the table and actually view the table.

When I go to view the web page in an Internet Exlporer 8 browser I get the error message below.
On Line 8 that ithe error refers to it says
BareDieDataSheets.ActiveConnection = MM_OpenOrdersCustomer_STRING
How do I fix this error as I am not a programmer?
Thank you...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine could not find the object '(unknown)'. Make sure the object exists and that you spell its name and the path name correctly.
/BareDieDataSheets.asp, line 8
Question by:ES-Components
    LVL 14

    Expert Comment

    Can you post the rest of the ASP (or at least lines 1 - 8) ?

    (just obscure the PWD=XXX part of your connection string).


    Author Comment

    Here is the code you requested.
    Thank you...

    <!--#include file="Connections/OpenOrdersCustomer.asp" -->
    Dim BareDieDataSheets
    Dim BareDieDataSheets_numRows

    Set BareDieDataSheets = Server.CreateObject("ADODB.Recordset")
    BareDieDataSheets.ActiveConnection = MM_OpenOrdersCustomer_STRING
    BareDieDataSheets.Source = "SELECT * FROM BareDieDataSheets"
    BareDieDataSheets.CursorType = 0
    BareDieDataSheets.CursorLocation = 2
    BareDieDataSheets.LockType = 1
    LVL 14

    Accepted Solution

    Thanks, Rick. It looks like the definition for MM_OpenOrdersCustomer_STRING is set in the file:
    Can you search that file for lines like:

    MM_OpenOrdersCustomer_STRING = . . .

    I'm guessing that there is a file path that
     can be resolved on your local machine (works in DreamWeaver) that cannot be resolved on the server (doesn't work in IE).


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now