Solved

Dreamweaver 8 recordset can't be viewed

Posted on 2007-03-28
5
264 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
ID: 18807414
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
ID: 18811766
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
ID: 18812878
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
ID: 18814234
>> 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
ID: 18815226
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 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