Solved

Dreamweaver 8 recordset can't be viewed

Posted on 2007-03-28
5
271 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Recordset containing single quotes 8 51
Unexpected End of File 11 83
Display if field is NOT "" or NOT null 6 35
Save data in two Database, Asp 2 67
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

737 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