Solved

Dreamweaver 8 recordset can't be viewed

Posted on 2007-03-28
5
259 Views
Last Modified: 2010-05-18
Hi:
I am using IIS5.0, asp/vbscript and Dreamweaver 8.  I am using one computer to develpe and text so URL prefix for testing SErver is http://Localhost.mysite/.  I have an access database connected successfully to my site. After adding a recordset the test was successful; it returned all the selected colums.  However, when I tried to view the web page  in internet Explorer the page cannot be open. It returned a 500.100 error. Please advise what could be the problem.

Thanks
0
Comment
Question by:causewaybay
  • 2
  • 2
5 Comments
 
LVL 25

Assisted Solution

by:Rouchie
Rouchie earned 200 total points
Comment Utility
Open IE, Tools, Internet Options, Advanced Options and uncheck the "show friendly http errors" property.  Does the error now give any more information?
0
 

Author Comment

by:causewaybay
Comment Utility
Dear Rouche:
Thank you! Following is the error information:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

...[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

/siteName/FolderName/fileName.asp, line 8 ...

Also please see the line 8 code:
<%
Dim rsProduct
Dim rsProduct_numRows

Set rsProduct = Server.CreateObject("ADODB.Recordset")
rsProduct.ActiveConnection = MM_connStarlyDB_STRING                     (THIS IS THE LINE 8)
rsProduct.Source = "SELECT * FROM Inventory"
rsProduct.CursorType = 0
rsProduct.CursorLocation = 2
rsProduct.LockType = 1
rsProduct.Open()

rsProduct_numRows = 0
%>
Thanks!
0
 
LVL 3

Accepted Solution

by:
stejam earned 300 total points
Comment Utility
G'day,

The Microsoft site covers this error; its causes and its solutions:

http://support.microsoft.com/kb/306269/

cheers

0
 
LVL 25

Expert Comment

by:Rouchie
Comment Utility
>> The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

This error usually means that you have the database open in Access while ASP is also trying to connect to it.  Close Access down and then run the ASP page.
0
 

Author Comment

by:causewaybay
Comment Utility
Thank You! Problem solved!  It's a user permission problem.  However, the access data appears unstable though it can be viewed.  I have to do compact and repair almost each time I try to open the record set.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

743 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

18 Experts available now in Live!

Get 1:1 Help Now