| :: 0x800A005B on Build Report :: (5) | Post a New Message | Post a Reply |
 0x800A005B on Build Report | Post a Reply |
since: Sep 18, 2005
from: somewhere
The second is after building a report and clicking the <Finish> button. It returns "0x800A005B Object variable or with block variable not set" and points to the OLE connection string as the offending line. It also states the POST data it is trying to use with Default.asp
This is the cut/paste'd sample in the tutorial using the Northwind.mdb database with no changes to the text other than to point to the correct file location (which is the same as the Default.asp sample page).
The demo is on an WinXP SP2 (no firewall) machine with latest patches. iiS has Read/Write privs on the directory, and all other instructions as per the documents. The ASP Wizard is 2.0.0.579
I've searched in the forums, but the only hits on 0x800A005B deals with installation errors, which I did not have.
Have you seen this & can tell me if something else is required?
Thanks... Joe
------
P.S. -- Just to make sure I explain everything -- the program works fine up until the point of pressing the <Finish> button. At that point, the ASP errors are displayed as explained above.
 Re: 0x800A005B on Build Report | Post a Reply |
from: Washington, DC
Try this:
1. Make sure that the folder in which your sample asp page is located has read/write permissions.
2. Also make sure that this folder is not Read-Only
The report wizard uses the file
Also make sure you
reports.xml file has the following structure <report_wizard version="2">
<groups>
<group id="" title =" General Reports " />
</groups>
<reports />
</report_wizard>
<groups>
<group id="" title =" General Reports " />
</groups>
<reports />
</report_wizard>
-------------------------
Ghost
| Re: 0x800A005B on Build Report | Post a Reply |
since: Sep 18, 2005
from: somewhere
I tried your suggestions:
1) The folder already had R/W permissions as per the User Docs, but I double-checked. [Read, Write, etc., plus Scripts Only Execute permissions]
2) I cut/pasted your suggestions on the structure of the Reports.xml file. That got me a little further -- I now see:
Errors Occured!!
Error #-2147024891
Access is denied.
twice, and then a final:
Errors Occured!
Could not save report
------------
This now sounds like read/write permissions, but I don't know what next to check... Nothing is showing-up in the WWW log files (other than stating access allowed) or in the WinXP Event Logs.
------------
Recap:
a) iiS 5.1 on a WinXP SP2 machine (firewall turned-off but all latest patches) for Demo/testing purposes before placing on live system/server.
b) iiS is default location of C:\InetPub\wwwroot\ -- R/W permissions set on subfolder where Default.asp resides.
c) Files inside demo folder are: Default.asp, locale_en.xml, Northwind.mdb, Reports.xml. [Northwind.mdb is from Access2003-SP1 which is what is on this machine -- I hope OLE connection string hasn't changed somehow with this version...]
d) Default.asp looks like:
<%
Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection string
objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Inetpub\wwwroot\Consumerism\Northwind.mdb;")
'put this where you want your reports
objWiz.DisplayReports
Set objWiz = Nothing
%>
e) ASP Report Wizard 2 (v2.0.0.579) with default install location of C:\Program Files\AspWebSolution -- two files in this directory [AWSReportWizard2.dll and msado25.tlb]
------------
Thanks... Joe
| Re: 0x800A005B on Build Report | Post a Reply |
from: Washington, DC
Make sure that your reports folder is registered as an application under IIS and also that your reports folder/file is not read-only
Also check out the following posts
http://aspwebsolution.com/forums/?tid=1174
http://aspwebsolution.com/forums/?tid=1323
-------------------------
Ghost
 Re: 0x800A005B on Build Report | Post a Reply |
since: Sep 18, 2005
from: somewhere
1) I double-checked again & the folder was *not* Read-Only.
2) I looked at & followed the instructions under the two posts (marked below), but no dice.
http://aspwebsolution.com/forums/?tid=1174
http://aspwebsolution.com/forums/?tid=1323
3) Finally on a hunch, I went into Windows Explorer, rt-clicked on the subfolder this particular ASP resides in; and under the Security tab, gave the IUSR account Read/Execute, List, and Write privs. Things started working !!! [i.e. - can see the Northwind Employees table as a webreport after clicking <Finish> ]
Not sure how kosher this is & will have to ponder on the ramifications some more, but at least I'm able to generate web reports & can do the Demo to determine whether this app will fill the needs.
If you have any additional thoughts, I'd appreciate hearing.
Thanks for your assistance !!!