AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: Help Please :: (5)

Apr 24 2006, 10:52 AM

Help Please

mfreeze

since: Apr 24, 2006
from: Clinton, NJ Help please.

I am evalualing ASPWebSolutions Report Wizard and can't get past the 'setting up your first reporting application'.

The first errors I received when I tried to use the example from the documentation stated that 'set' was no longer supported and I had to change the file to fix these as well as some other errors I was receiving.. Next, I got the Object variable or With block variable not set error. I found a posting about the reports.xml file and created that but am still getting the error.

I am running asp.net framework 1.1 on a windows 2003 server and have placed the default.aspx file I am using below. Can somebody help me?

<%@ Page Language="VB" ASPCOMPAT="TRUE" Debug="true" %>
<%

Dim AspwebSolution

Dim 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=MSDASQL;Driver={SQL Server};" & _
"ffg001sq2;Database=ac_serenecomfort;" & _
"User ID=sa;Password=yourno1son;")

%>
<html>
<head>
<title>Simple Reports</title>
</head>
<body scroll="auto">
<%
'put this where you want your reports
objWiz.DisplayReports
%>
</body>
</html>
<%
objWiz = Nothing

%>

Apr 25 2006, 5:13 AM

Re: Help Please

Post a Reply

ghost

from: Washington, DC Try using an asp file rather than an aspx.
P/S: Remember to enable scripting support for the web folder in IIS...win2k3 comes with ASP disabled by default.

-------------------------
Ghost

Apr 26 2006, 9:43 AM

Re: Help Please

Post a Reply

mfreeze

since: Apr 24, 2006
from: Clinton, NJ I tried changing the extension to asp and that didn't work. After more research, I ran tlbimp and placed the output into a bin subdirectory in the folder containing my index file. I also tried putting it in the aspreports installaton directory.

Now I am getting System.Runtime.InteropServices.COMException: Type mismatch.

Any ideas?

Apr 26 2006, 10:27 AM

Re: Help Please

Post a Reply

mfreeze

since: Apr 24, 2006
from: Clinton, NJ Ok. I changed my code and got past the mismatch error. Now I am getting Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 8: 'Make sure you initialize before adding any HTML text
Line 9: 'TODO Change this to your actual connection string
Line 10: objwiz.init("Provider=MSDASQL;Driver={SQL Server};" & _
Line 11: "ffg001sq2;Database=ac_serenecomfort;" & _
Line 12: "User ID=xx;Password=xxxxxxx;")

Apr 28 2006, 10:03 AM

Re: Help Please

Post a Reply

ghost

from: Washington, DC Windows 2003 comes pretty much locked down with scripting, file system permissions, COM object security pretty much disbaled.
You will have to enable ASP scripting and web access permissions on the AWSReportWizard.dll file if need be.

-------------------------
Ghost

Pages: (1) [1]