[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Microsoft ODBC Error - Can It Be Fixed?

Posted on 2012-08-15
3
Medium Priority
?
919 Views
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...
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
0
Comment
Question by:ES-Components
  • 2
3 Comments
 
LVL 14

Expert Comment

by:pteranodon72
ID: 38297741
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
 

Author Comment

by:ES-Components
ID: 38299862
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
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 2000 total points
ID: 38300803
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

873 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