Microsoft ODBC Error - Can It Be Fixed?

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...
Rick

ERROR MESSAGE
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
ES-ComponentsAsked:
Who is Participating?
 
pteranodon72Commented:
Thanks, Rick. It looks like the definition for MM_OpenOrdersCustomer_STRING is set in the file:
Connections/OpenOrdersCustomer.asp
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).

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

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

-pT72
0
 
ES-ComponentsAuthor Commented:
Here is the code you requested.
Thank you...
Rick

<%@LANGUAGE="VBSCRIPT"%>
<!--#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
BareDieDataSheets.Open()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.